Display "0" for negative numbers

B

Bryce

How do I write a function that displays "0" when a negative number is the
result of a sum?
 
J

JE McGimpsey

One way:

=MAX(0,SUM(A1:A4))

Or, if you just want to display 0, not change the value to 0

Format/Cells/Number/Custom General;\0;General;@
 

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

Excell - two conditions count if factors are true when negative nu 2
SUMIF with broken range 10
Divide two cells and if the number is negative display is as zero 2
Rounding Negative Numbers to Zero 4
Conditional format 1
Need Help with "SUM" AND "ABS" in same formula 12
IF and SUMIF 9
Validation of UK VAT Number 21

Top