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

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.

Practice

1. Which arithmetic operator in Excel is used for multiplication in a formula like =A1 * B1?

easy

A. + (plus)

B. * (asterisk)

C. - (minus)

D. / (slash)

Solution

1. Step 1: Identify the multiplication operator

   In Excel formulas, the asterisk (*) is used to multiply values.

2. Step 2: Confirm the operator in the example

   The formula =A1 * B1 uses the asterisk to multiply the values in cells A1 and B1.

3. Final Answer:

   * (asterisk) -> Option B

4. Quick Check:

   Multiplication = * [OK]

Hint: Remember * means multiply in Excel formulas [OK]

Common Mistakes:

• Confusing * with + for addition
• Using x instead of *
• Using / for multiplication

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

easy

A. =A1 + B1

B. =A1 - B1

C. =A1 * B1

D. =A1 / B1

Solution

1. Step 1: Identify the addition operator

   The plus sign (+) is used to add numbers in Excel formulas.

2. Step 2: Check the formula syntax

   The formula =A1 + B1 correctly adds the values in cells A1 and B1.

3. Final Answer:

   =A1 + B1 -> Option A

4. Quick Check:

   Addition = + [OK]

Hint: Use + to add numbers in Excel formulas [OK]

Common Mistakes:

• Using - instead of +
• Forgetting the = sign
• Using * for addition

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

medium

A. 25

B. 30

C. 15

D. 20

Solution

1. Step 1: Apply order of operations

   Excel calculates multiplication before addition, so 5 * 2 = 10.

2. Step 2: Add the results

   Then add 10 + 10 = 20.

3. Final Answer:

   20 -> Option D

4. Quick Check:

   10 + (5 * 2) = 20 [OK]

Hint: Multiply before adding unless parentheses change order [OK]

Common Mistakes:

• Adding first then multiplying
• Ignoring operator precedence
• Confusing * with +

4. The formula =A1 + B1 * returns an error. What is the problem?

medium

A. Formula should start with a single quote

B. Using + instead of -

C. Missing value after the * operator

D. Parentheses are required around A1 and B1

Solution

1. Step 1: Check formula completeness

   The formula ends with an operator * but has no value after it, which is invalid.

2. Step 2: Understand Excel syntax rules

   Every operator must have values on both sides; missing value causes an error.

3. Final Answer:

   Missing value after the * operator -> Option C

4. Quick Check:

   Operators need values on both sides [OK]

Hint: Ensure every operator has values before and after [OK]

Common Mistakes:

• Leaving operator at end
• Forgetting to complete formula
• Adding unnecessary parentheses

5. You want to calculate the total price with tax in Excel. The price is in cell A2, and tax rate (as decimal) is in B2. Which formula correctly calculates price plus tax?

hard

A. =A2 + B2 * A2

B. =(A2 + B2) * A2

C. =A2 + B2

D. =A2 + B2 + A2

Solution

1. Step 1: Understand the calculation

   Total price with tax = price + (price x tax rate).

2. Step 2: Match formula to calculation

   Formula =A2 + B2 * A2 correctly adds price plus tax amount (B2 * A2).

3. Final Answer:

   =A2 + B2 * A2 -> Option A

4. Quick Check:

   Price + (TaxRate x Price) = Total [OK]

Hint: Multiply tax rate by price, then add price [OK]

Common Mistakes:

• Adding tax rate directly
• Multiplying sum incorrectly
• Using wrong operator order