J
James23
How do I get a simple addition formula to return a zero in a cell if the
formula yields a negative number?
formula yields a negative number?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=IF(A1+A2<0,0,A1+A2)
D
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?
J
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.
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.
J
James23
J
James23
This is my cell:
=MAX(0,((N29-(K29+L29+M29)-40)))
=MAX(0,((N29-(K29+L29+M29)-40)))
D
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.
formula, when adding and subtracting, it doesn't matter the order in which
you do it.
D
David Biddulph
.... though of course the parentheses around K29+L29+M29 *are* significant.