Display "0" for negative numbers

  • Thread starter Thread starter Bryce
  • Start date Start date
B

Bryce

How do I write a function that displays "0" when a negative number is the
result of a sum?
 
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;@
 
Back
Top