Arithmetic operators in Google Sheets - Step-by-Step Guide

Introduction

Arithmetic operators let you do math in your spreadsheet. You can add, subtract, multiply, divide, and more. This helps you calculate totals, differences, and other numbers easily.

When you want to add prices in a shopping list to find the total cost

When you need to subtract expenses from income to see your savings

When calculating the area by multiplying length and width values

When dividing a total bill among friends to find each person's share

When using percentages to find discounts or tax amounts

Steps

Step 1: Click

- a blank cell where you want the result

The cell is selected and ready for input

Step 2: Type

- the formula bar or directly in the selected cell

The formula appears in the cell and formula bar

💡 Start every formula with an equal sign (=) to tell Sheets you are entering a formula

Step 3: Enter

- an arithmetic expression using operators like +, -, *, /

The formula calculates and shows the result in the cell

💡 Use + for addition, - for subtraction, * for multiplication, and / for division

Step 4: Press

- Enter key

The formula is saved and the result is displayed in the cell

Step 5: Click

- another cell and repeat with different numbers or cell references

You can perform more calculations using arithmetic operators

Before vs After

Before

Cell A1 has 10, Cell A2 has 5, and Cell A3 is empty

After

In Cell A3, formula =A1+A2 shows 15 as the sum of 10 and 5

Settings Reference

Formula input

📍 Formula bar or cell

To enter arithmetic calculations

Default: No formula by default

Cell format

📍 Format menu > Number

To display calculation results in the desired number format

Default: Automatic

Common Mistakes

Typing a formula without starting with =

Sheets treats it as plain text, not a formula, so no calculation happens

Always start formulas with an equal sign, for example, =A1+A2

Using the wrong operator symbol, like x instead of * for multiplication

Sheets does not recognize x as multiplication, so it shows an error

Use * for multiplication, for example, =A1*A2

Dividing by zero or an empty cell

This causes a #DIV/0! error because division by zero is not allowed

Make sure the divisor cell has a number greater than zero

Summary

Arithmetic operators let you do basic math like add, subtract, multiply, and divide in Google Sheets.

Always start your formula with = and use the correct symbols: +, -, *, /.

Check for common errors like missing = or dividing by zero to get correct results.

Practice

1. Which arithmetic operator in Google Sheets is used to multiply two numbers?

easy

A. +

B. *

C. /

D. ^

Solution

1. Step 1: Recall basic arithmetic operators

   The multiplication operator in spreadsheets is the asterisk symbol *.

2. Step 2: Match operator to multiplication

   Among the options, only * represents multiplication.

3. Final Answer:

   * -> Option B

4. Quick Check:

   Multiplication = * [OK]

Hint: Remember * means multiply in formulas [OK]

Common Mistakes:

• Confusing + with multiplication
• Using ^ for multiplication
• Using / instead of *

2. Which of the following is the correct formula to add the values in cells A1 and B1 in Google Sheets?

easy

A. =A1+B1

B. A1+B1

C. =SUM(A1 B1)

D. =A1*B1

Solution

1. Step 1: Understand formula syntax

   Formulas must start with an equals sign = to calculate values.

2. Step 2: Identify correct addition syntax

   The correct way to add two cells is =A1+B1. =A1*B1 multiplies instead, A1+B1 misses the equals sign, and =SUM(A1 B1) has wrong syntax.

3. Final Answer:

   =A1+B1 -> Option A

4. Quick Check:

   Formula starts with = and uses + for addition [OK]

Hint: Always start formulas with = and use + for addition [OK]

Common Mistakes:

• Omitting = at start
• Using * instead of +
• Wrong SUM syntax without comma

3. What is the result of the formula =10 + 5 * 2 in Google Sheets?

medium

A. 20

B. 15

C. 30

D. 25

Solution

1. Step 1: Apply order of operations

   Multiplication (*) is done before addition (+), so calculate 5 * 2 = 10 first.

2. Step 2: Add the results

   Then add 10 + 10 = 20.

3. Final Answer:

   20 -> Option A

4. Quick Check:

   Multiplication before addition = 20 [OK]

Hint: Multiply before adding in formulas [OK]

Common Mistakes:

• Adding before multiplying
• Ignoring operator precedence
• Calculating left to right only

4. The formula =A1 + * B1 gives an error in Google Sheets. What is the correct fix?

medium

A. =A1 + (B1

B. =A1 * B1

C. =A1 + B1 *

D. =A1 + B1

Solution

1. Step 1: Identify syntax error

   The formula has an invalid operator sequence + * which is not allowed.

2. Step 2: Correct the formula

   Remove the extra operator to get =A1 + B1, which adds the two cells correctly.

3. Final Answer:

   =A1 + B1 -> Option D

4. Quick Check:

   Only one operator between operands [OK]

Hint: Use only one operator between values [OK]

Common Mistakes:

• Using two operators together
• Leaving trailing operators
• Missing equals sign

5. You want to calculate the total cost in cell C1 by multiplying quantity in A1 by price in B1, then adding a fixed shipping fee of 5. Which formula correctly does this?

hard

A. =A1 * (B1 + 5)

B. A1 * B1 + 5

C. =(A1 * B1) + 5

D. =A1 + B1 * 5

Solution

1. Step 1: Understand calculation order

   You must multiply quantity and price first, then add shipping fee.

2. Step 2: Use parentheses to ensure correct order

   Formula =(A1 * B1) + 5 ensures multiplication happens before addition. A1 * B1 + 5 misses the equals sign; C adds shipping to price before multiplying (wrong); D multiplies price by 5 then adds quantity (wrong).

3. Final Answer:

   =(A1 * B1) + 5 -> Option C

4. Quick Check:

   Multiply first, then add shipping with parentheses [OK]

Hint: Use parentheses to control calculation order [OK]

Common Mistakes:

• Adding before multiplying
• Wrong operator placement
• Missing parentheses causing wrong results