if/then formula help

R

Roger

I would like a if/then formula to look at a cell and if that cell is equal or
less than zero to simply product a zero, not a negative. Or any other
formula that would do this... Just thought it would be an if/then..

thanks in advance.
 
T

T. Valko

What do want to do if the cell is greater than 0?

=IF(A1<=0,0,A1)

Or, to make it more robust:

=IF(ISNUMBER(A1),IF(A1<=0,0,A1),0)

Biff
 
Top