ExcelBanter - HOW TO GET A SUM TO NOT EQUAL A NEGATIVE

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW TO GET A SUM TO NOT EQUAL A NEGATIVE (https://www.excelbanter.com/excel-worksheet-functions/108233-how-get-sum-not-equal-negative.html)

tee

HOW TO GET A SUM TO NOT EQUAL A NEGATIVE

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

tee

HOW TO GET A SUM TO NOT EQUAL A NEGATIVE

Sorry about the all caps in subject line :-)

"Tee" wrote:

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

Roger Govier

HOW TO GET A SUM TO NOT EQUAL A NEGATIVE

Hi Tee

Try
=MAX(0,I1-240)

--
Regards

Roger Govier

"Tee" wrote in message
...
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

tee

HOW TO GET A SUM TO NOT EQUAL A NEGATIVE

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

"Roger Govier" wrote:

Hi Tee

Try
=MAX(0,I1-240)

--
Regards

Roger Govier

"Tee" wrote in message
...
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

All times are GMT +1. The time now is 02:58 AM.