Basic Arithmetic Formulas in Excel: Step-by-Step

A colleague, Priya, sat next to me one afternoon with a printed spreadsheet covered in handwritten totals — numbers she'd been adding on a calculator and typing in by hand. She'd been doing this every week. When I asked why she wasn't using formulas, she said the documentation she'd found made it feel complicated. I closed the PDF she'd been reading, opened a blank workbook, and we rebuilt the whole thing around her actual data. "This is the first time this has made sense," she said about ten minutes in.

That's the approach this guide takes. You'll write working Excel arithmetic formulas for addition, subtraction, multiplication, and division — using both operators and functions — and you'll build the one habit that prevents most beginner mistakes before they happen. No abstract A1/B1 examples. We'll use a real scenario throughout: a simple Coffee Shop Inventory Tracker, tracking units, prices, and totals.

What You'll Be Able to Calculate — and One Excel Arithmetic Formula Habit to Build From the Start

By the end of this guide, you'll write addition, subtraction, multiplication, and division formulas in Microsoft Excel using both direct operators and named functions. You'll know when to use each, and you'll have a solid read on operator precedence — the rule that actually controls how Excel calculates your results.

The one habit: every formula in Microsoft Excel starts with an equals sign. Not the number. Not the cell reference. The = sign. Skip it, and Excel treats your formula as plain text — it just sits there in the cell doing nothing. Type = first, every single time, and you'll avoid the most common stumble beginners hit on day one. You'll see this reflected in the formula bar at the top of the screen as you type. If your company runs Microsoft 365, everything in this guide works exactly as described.

If you're newer to spreadsheets in general, the Excel for Beginners starter guide is worth a read before this one — it covers the interface basics so you're not context-switching while learning formulas.

---

Step 1: Write Your First Arithmetic Formulas in Excel Using the Four Core Operators

Before touching any function, write formulas with raw operators. There's a reason for this: functions are abstractions built on top of operators, and if you don't understand the operators first, the functions feel like magic you can't control. In our Coffee Shop Inventory Tracker, column A holds product names, column B holds unit count, and column C holds cost per unit.

Addition and Subtraction: The + and − Operators

Click into an empty cell — say D2 — and type =B2+C2 to add two cell references together. Press Enter. That's addition. Subtraction works exactly the same way: =B2-C2 subtracts C2 from B2. Both formulas live in the formula bar and reference the cells rather than hard-coding numbers, which means if B2 changes, your result updates automatically. That's the whole point of using cell references instead of typing values directly.

Multiplication and Division: The * and / Operators

Multiplication in Excel uses an asterisk, not an ×: =B2*C2 gives you units multiplied by cost per unit — your total inventory value for that row. Division uses a forward slash: =B2/C2. These are the basic math formulas in Excel you'll use constantly. The asterisk trips people up at first, but it becomes automatic fast.

Once you've written these four formulas by hand, you've built the muscle memory you need. Now you're ready to see where named functions fit in — and why SUM, specifically, earns its place.

---

Step 2: Use the SUM Function (and Know When It Beats the Plus Operator)

The four operators above work fine for two-cell math. The moment you're adding more than two values, chaining plus signs becomes a liability: =B2+B3+B4+B5+B6+B7+B8+B9+B10 is eight places to make a typo. There's a better way.

When to Use SUM Instead of the + Operator

The SUM function takes a range: =SUM(B2:B10). Nine cells, one formula, zero extra operators to mistype. A simple personal rule: two cells, use +. Three or more, use SUM. The introduction to SUM on this site covers the full syntax if you want to go deeper.

Two more functions worth knowing here. For exponents (like squaring a number), Excel has the POWER function: =POWER(B2,2) squares whatever's in B2. For the remainder after division, MOD handles it: =MOD(B2,C2) gives you what's left over. These are the function equivalents for two operations that don't have clean single-character operators. Google Sheets supports both the same way, so your formulas transfer cleanly if you switch platforms.

For a broader look at how functions differ from raw operators structurally, the difference between formulas and functions in Excel is a genuinely useful read — not just semantics, it changes how you think about formula design.

---

Step 3: Control Order of Operations So Excel Arithmetic Formulas Calculate What You Actually Mean

Now that you've used both operators and functions, there's one more layer you need before your formulas are fully reliable: Excel follows BODMAS/PEMDAS just like standard math. Multiplication and division happen before addition and subtraction, always, unless you use parentheses to override it.

=2+3*4 returns 14, not 20. Excel multiplies 3×4 first, then adds 2. If you meant to add 2+3 before multiplying, you need =(2+3)*4, which returns 20. This is Excel formula operator precedence in action, and misunderstanding it is how reports quietly produce wrong numbers for weeks before anyone notices.

One operator most beginner guides skip: the % operator. Type =B2*15% and Excel applies 15 percent directly — no need to type 0.15 separately. Clean, readable, and underused.

---

Common Mistakes With Excel Arithmetic Formulas (Including the #DIV/0! Error Most Guides Never Explain)

Three stumbles come up constantly, and none of them mean something is fundamentally broken.

1. Forgetting the equals sign. Your formula displays as text. Add the = and you're done.
2. The #DIV/0! error. This fires when your division formula references an empty or zero-value cell as the divisor. Excel can't divide by zero — nobody can — and it tells you so. The fix is wrapping your formula with IFERROR: =IFERROR(B2/C2, 0) returns zero instead of the error when C2 is empty. You can swap that 0 for a dash or a short message if you want something more readable in a report.
3. The #VALUE! error. This means your formula has hit a text cell where it expected a number. Check your cell references. One of them contains a word, a label, or — as I once discovered after forty-five minutes of troubleshooting — a rogue space character. We've all been there.

If you drag any of these formulas down a column and your totals look wrong, check whether you needed to lock a reference with $. A formula like =B2*$C$1 locks C1 in place as you drag. A misplaced relative reference once inflated a quarterly report by 12% before anyone noticed. It's in every Common Mistakes section for a reason.

For a deeper look at how cell references behave when you copy or drag formulas, relative vs. absolute references explained covers exactly that.

Open a blank workbook and build one formula with real numbers from your own life — a monthly expense, a running total, anything. That's when it sticks.

---