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

  • Thread starter Thread starter James23
  • Start date Start date
J

James23

How do I get a simple addition formula to return a zero in a cell if the
formula yields a negative number?
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

replace a negative result with a zero? 2
Dividing - Negative Number by Zero 5
Returning Zero 10
Red cell for negative numbers in Excel 1
Replacing negative formual results with a zero. 2
Trying to reconcile a column 1
Pick the low number in a column of Numbers 3
display negative numbers as zero 3

Back
Top