if/then formula help

[Guest]

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. 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

 

[Guest]

try

=MIN(A1,0)

 

[T. Valko]

Pretty sure you have a typo there:

try
=MIN(A1,0)

=MAX(A1,0)

Biff