ADD

The ADD function in Google Sheets returns the sum of two numbers, working exactly like the + operator. While most users simply type =A1+A2, the ADD function offers a formulaic, function-style equivalent that can be useful when composing formulas dynamically. Dive into our comprehensive guide to see how it works.

Parameters

• value1: The first number to add.
• value2: The second number to add.

Step-by-Step Tutorial

1. Using ADD with two numbers:

   • Example: =ADD(3, 5)
   • Result: 8

2. Using ADD with cell references:

   • Example: If A1 is 10 and B1 is 25, then =ADD(A1, B1) will return 35.

Use Cases and Scenarios

1. Programmatic Formulas: Use ADD inside larger formulas built with functions like LAMBDA or ARRAYFORMULA where a function form is easier to compose than an operator.
2. Consistency with Other Operator Functions: Pair with MINUS, MULTIPLY, and DIVIDE for a uniform, function-based approach to arithmetic.
3. Teaching and Documentation: Make formula logic more explicit and readable for people learning spreadsheet basics.

Related Functions

• SUM: Add up a series of numbers or ranges, useful for more than two values.
• MINUS: Returns the difference of two numbers.
• MULTIPLY: Returns the product of two numbers.

Related Articles

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know