T
Terence
Is it possible to format a cell where if the cell value is negative then
change the value to zero?
Thanks for your help!
change the value to zero?
Thanks for your help!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave F
Are the cell values derived from formulas? Then just set the formula value
to zero if the formula calculation is less than zero: =IF(A1*B1<0,0,A1*B1),
etc.
Dave
to zero if the formula calculation is less than zero: =IF(A1*B1<0,0,A1*B1),
etc.
Dave
T
Teethless mama
=MAX(your formula,0)
G
Gord Dibben
Or by using event code which looks at the value in the cell and changes to 0 if
negative.
No formulas involved, just VBA
Gord Dibben MS Excel MVP
negative.
No formulas involved, just VBA
Gord Dibben MS Excel MVP
T
Terence
Thanks Dave, that worked perfect!
Dave F said:Are the cell values derived from formulas? Then just set the formula value
to zero if the formula calculation is less than zero: =IF(A1*B1<0,0,A1*B1),
etc.
Dave