0
0
Excelspreadsheet~5 mins

Arithmetic operators in formulas in Excel - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
Arithmetic operators let you do math inside Excel cells. You can add, subtract, multiply, or divide numbers easily using formulas. This helps you calculate totals, differences, or other values automatically.
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 profit
When calculating area by multiplying length and width values
When dividing a total bill among friends to find each share
When you want to increase a number by a percentage using multiplication
Steps
Step 1: Click
- any empty cell where you want the result
The cell is selected and ready for input
Step 2: Type
- the selected cell
The formula starts with an equal sign (=) to tell Excel you are entering a formula
💡 Always start formulas with = to make Excel calculate them
Step 3: Type
- the formula bar or cell
You enter numbers and arithmetic operators like +, -, *, or / to build your formula
💡 Use + for addition, - for subtraction, * for multiplication, and / for division
Step 4: Press
- Enter key on your keyboard
Excel calculates the formula and shows the result in the cell
Step 5: Click
- another cell
The formula result stays visible in the original cell
Before vs After
Before
Cell A1 is empty, cell A2 is empty
After
Cell A1 shows 5, cell A2 shows 3, cell A3 shows the formula =A1+A2 with result 8
Settings Reference
Formula calculation mode
📍 Formulas tab > Calculation group > Calculation Options
Controls when Excel recalculates formulas after changes
Default: Automatic
Common Mistakes
Typing a formula without the equal sign, like A1+A2
Excel treats it as text and does not calculate
Always start formulas with =, for example =A1+A2
Using a comma instead of a period for decimal points in formulas
Excel may not recognize the number correctly depending on regional settings
Use the correct decimal separator for your Excel version, usually a period (e.g., 3.5)
Summary
Arithmetic operators let you do math inside Excel formulas easily.
Start formulas with = and use +, -, *, / for addition, subtraction, multiplication, and division.
Excel calculates and shows the result automatically when you press Enter.