Google Sheets – Sum of Two Numbers with a Minimum of Zero

google sheets

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?

Best Answer

You can use the MAX function for this, since

MAX( A3+B3, 0 )

will return 0, when the sum is negative.