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.