Home |
Search |
Today's Posts |
#6
|
|||
|
|||
Thanks Dave!
That did it. Chet On Thu, 06 Oct 2005 19:01:54 -0500, Dave Peterson wrote: How about just: =max(0,youroriginalformulahere) If your formula returns -3, then 0 is larger and will be returned. If your formula returns +33, then that's bigger than 0. So you'll see 33. Chet T wrote: Hi all, Is there any way to automatically change any negative numbers in a cell to zero? For a spend down spreadsheet that I am developing, any negative numbers will be zero. I could not find a format or function that would do it. I would like to avoid the =if(.......0,......,0) route because the formula in the cell already contains an if argument and it is already too complicated. Would an array formula work? I haven't worked with them too much. Any advice is appreciated. TIA Chet -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
Can I calculate negative numbers to = zero in excel? | Excel Discussion (Misc queries) | |||
Using Replace to Format Negative Numbers | Excel Discussion (Misc queries) | |||
Negative numbers | Excel Discussion (Misc queries) | |||
Putting numbers in excel without it changing into a formula? | Excel Worksheet Functions |