HOW TO GET A SUM TO NOT EQUAL A NEGATIVE

[Guest]

I have formulated my columns as needed. My final cell (J) needs to be
formulated where it will not end up as a negative.
EX.A
formulated cell (I) total is 230. Final cell (J) needs to be minus 240, but
total needs to be 0. not -10.
EX.B
formulated cell (I) total is 300. Final cell (J) needs to be minus 240,
total s/b 60.

Im sure there is a way, but I do not know it.
Can someone help?
Thanks Tee

 

[Guest]

Sorry about the all caps in subject line

 

[Roger Govier]

Hi Tee

Try
=MAX(0,I1-240)

 

[Guest]

Thanks Roger.... That worked. Have a great weekend!