MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Displaying Zero When Sum is Negative


Posted by Michael on March 05, 2001 6:14 AM

I have a series of sums. They could be positive, zero or negative. When the sum is negative I would like to display zeroes. Is this possible?


Posted by Dave Hawley on March 05, 2001 6:26 AM


Hi Micheal

A simple IF formula should solve this for you:

=IF(SUM(A1:A10)<0,0,SUM(A1:A10))


Any good ?


OzGrid Business Applications

Posted by Dunk on March 09, 2001 5:42 PM

Alternatively

To save excel having to calculate the sum twice, use:-

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