I have a Google Spreadsheet with two columns of numbers (A & B). I want to add these numbers together and put the result into a third column (Results).

If the sum of these two numbers is less than zero, I would like the result column to have zero instead of a negative number.

I found this list of Google Spreadsheet function,but I did not see one that is applicable.

| A  | B | Results | Calculation in result column:   =Sum(A1:B1) 
| 1  | 3 |       4 | <= Normal and good, 
| 1  |-3 |       0 | <= Good, this is what I am looking for 
| 1  |-3 |      -2 | <= Bad, this is what is happening.  

My question is:

  • How do you find the sum of two columns that will result in a minimum value?

3 Answers 3


You can use the MAX function for this, since

MAX( A3+B3, 0 )

will return 0, when the sum is negative.


In openoffice, I used the following:

 if(sum(a1:b1)>0; c1; 0)

This formula is placed in c1. It says that if the sum of A1 through B1 is greater than 0 then use the answer that is in C1 otherwise use 0.

I'm just assuming that googles' spreadsheet has somehthing similiar. I hope this works for you.

  • 1
    Better would be to know that in advance.
    – Jacob Jan
    Sep 22, 2013 at 15:03

This is the ARRAYFORMULA variant:


I didn't get the MAX to work with the ARRAYFORMULA.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.