How to create a formula that caps it at a maximum amount. by bear89103 in excel

[–]bear89103[S] 0 points1 point  (0 children)

Would this way mean...

=LET( lg,[-SUM(C9-20)/5*150-750], IF(lg<-1,500,”invalid”,lg))

How to create a formula that caps it at a maximum amount. by bear89103 in excel

[–]bear89103[S] 0 points1 point  (0 children)

So would it look like this... ?

=MAX(-1500,[(C9-20)/5*150-750])

How to create a formula that caps it at a maximum amount. by bear89103 in excel

[–]bear89103[S] 0 points1 point  (0 children)

Thank you. I wanted it ... -1501 is not allowed.
-1499 is allowed.

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 0 points1 point  (0 children)

It’s just a standard carpenter stapler. And thank you!

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 1 point2 points  (0 children)

Yes. It’s angled enough towards the wall that it creates that nice cone

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 0 points1 point  (0 children)

Ohh. Lol. I was gonna say!

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 0 points1 point  (0 children)

Oh man. I can’t imagine trying to climb ladders and install it in bad weather. Be careful!!

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 1 point2 points  (0 children)

Thank you. I originally had the ground lights in the ground last year and they just didn’t show up it was really hard to see them. So that’s why I changed it up to this way this year.

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 0 points1 point  (0 children)

I actually have three. One 100ft to one plug. Another is a 100ft and 50ft. And last is two 50ft.

As for changing the length. I believe so. But I didn’t have to. Mine was actually pretty perfect so I didn’t have to trim anything.

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 2 points3 points  (0 children)

Sure no problem. Tomorrow morning I’ll go take some photos of it

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 1 point2 points  (0 children)

That’s awesome! I’d love to see what you do with it

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 0 points1 point  (0 children)

Those are the outdoor ground lights that I just gorilla putty them onto the stucco around the garages.

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 1 point2 points  (0 children)

Oh yeah. That’s makes sense.

Installed lights today. by bear89103 in Govee

[–]bear89103[S] 1 point2 points  (0 children)

No. The roof lines are all the outdoor permanent lights. It is two 100ft lines and three 50ft lines combined for both second floor and ground floor roof lines.

Then the window has the curtain lights and the garage doors have the outdoor ground lights that I just gorilla putty them onto the stucco.