If the value of a cell is less than zero, what is the easiest way to
default it to zero?

example

b6 = -15
I want it to default to zero regaurdless of any other equation in the
cell.

b6 = 0


--
Custermd

Hi Custermd,

Is this what your after:

=IF(b60<0,0,b6)

Doesn't seem to post correctly on this forum.
Should read: =IF(CELL is less than {LEFT ARROW}0, Then Display 0, else
display the CELL)

Marcster.


--
Marcster

=IF(b60<0,0,b6)


--
Marcster