views:

37

answers:

2

I have a google spreadsheet that uses this function:

=SUM(E:E) - SUM(C:C)

It adds up all the values of column E and column C and them subtracts the difference. I would like to be able to return a 0 if the difference is negative.

+2  A: 

IF((SUM(E:E) - SUM(C:C))< 0,0,SUM(E:E) - SUM(C:C))

Femaref
A: 
=MAX(SUM(E:E) - SUM(C:C),0)
Kirschstein