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
|