| 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) | |||
Linear Mode
