if/then formula help
 

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.

if/then formula help
 

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

"Roger" wrote in message
...
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.

if/then formula help
 

try

=MIN(A1,0)


"Roger" wrote:

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.

if/then formula help
 

Pretty sure you have a typo the

try
=MIN(A1,0)

=MAX(A1,0)

Biff

"Duke Carey" wrote in message
...
try

=MIN(A1,0)


"Roger" wrote:

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.