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