Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make a negative response to if question equal zero | Excel Discussion (Misc queries) | |||
If the result of a formula is negative make equal to zero | New Users to Excel | |||
EQUAL SIGN | Excel Discussion (Misc queries) | |||
irritating warning for negative data on log charts | Charts and Charting in Excel | |||
Negative Values Only | Excel Discussion (Misc queries) |