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:


Any good ?

OzGrid Business Applications

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


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