Rounding Negative Numbers to Zero
On Tue, 14 Jul 2009 13:26:02 -0700, Robbie
wrote:
I've been searching around and can't seem to figure out how to write a
formula that will round a negative number to 0 correctly. I used the
(MAX(0,A1) and it seemed to work from that cell but another cell pulls the
value from that cell and it was still using the negative number to calculate.
I need a formula that will round the negative number to Zero and then use
the Zero from that roundup when other cells are referring to it.
Does that make sense?
Need help!!
Thanks,
Robbie
A1: your number
B1: =max(0,a1)
Have your other formulas either refer to B1; or in those cells, substitute
max(0,a1) for a1
--ron
|