Put this formula in any cell other than A1 and you will get a "0" if A1 is
less than zero (negative).
IF(A1<0,"0","Whatever")
If you want a given cell to change to "0" whenever its value goes negative,
you will need a macro. Post back if you need more. HTH Otto
"mike" wrote in message
...

Mike,
Or do you want the the value to be displayed as 0 in the actual cell (i.e.
no helper cell needed). If so this can be achieved with custom formats:

<Format
<Cells
Click on "Custom"
Enter this: General;"0"

This will display all positive values as their actual value as usual, but
display any negative values as simply 0. Note the negative value is still
located in the cell, it just "Looks" like it's 0.

--
Regards,
Dave


"Otto Moehrbach" wrote:

Put this formula in any cell other than A1 and you will get a "0" if A1 is
less than zero (negative).
IF(A1<0,"0","Whatever")
If you want a given cell to change to "0" whenever its value goes negative,
you will need a macro. Post back if you need more. HTH Otto
"mike" wrote in message
...

Hi Mike,
If the cell in question is a calculated cell, ie, it gets its value from a
formula, then just add an IF statement.
eg
IF(YourFormula<0,0,YourFormula)

"David Billigmeier" wrote:

Mike,
Or do you want the the value to be displayed as 0 in the actual cell (i.e.
no helper cell needed). If so this can be achieved with custom formats:

<Format
<Cells
Click on "Custom"
Enter this: General;"0"

This will display all positive values as their actual value as usual, but
display any negative values as simply 0. Note the negative value is still
located in the cell, it just "Looks" like it's 0.

--
Regards,
Dave


"Otto Moehrbach" wrote:

Put this formula in any cell other than A1 and you will get a "0" if A1 is
less than zero (negative).
IF(A1<0,"0","Whatever")
If you want a given cell to change to "0" whenever its value goes negative,
you will need a macro. Post back if you need more. HTH Otto
"mike" wrote in message
...