Returning zero if the results of a formula is a negative number?

[James23]

How do I get a simple addition formula to return a zero in a cell if the
formula yields a negative number?

 

[Gary''s Student]

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

 

[Dave Peterson]

=max(0,yourformula)

How do I get a simple addition formula to return a zero in a cell if the
formula yields a negative number?

 

[James23]

Bingo, thanks. Works perfect.

This is how my cell looks after your advice.

=IF((N31-(K31+L31+M31)-40)<0,0,(N31-(K31+L31+M31)-40))

As with any aspect of Excel, I'm sure there is a better way to do this, but
this is the best that I can come up with.

Thanks again.

 

[James23]

Thanks Dave.

That works very well too.

=max(0,yourformula)

 

[James23]

This is my cell:

=MAX(0,((N29-(K29+L29+M29)-40)))

 

[dlw]

You don't need all the parens, unless it helps with understanding the
formula, when adding and subtracting, it doesn't matter the order in which
you do it.

 

[David Biddulph]

.... though of course the parentheses around K29+L29+M29 *are* significant.