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)
