How to Write Your First Excel Formula (Step-by-Step)
Most people think Excel formulas are hard to learn. They're not — they're just taught badly. Every person I've met who says "I'm just not a spreadsheet person" was given a confusing first experience, not a bad brain. The formula itself isn't the problem.
I want to fix that here. This guide walks you through how to create an Excel formula from scratch, starting with the logic behind it, not just what to type. If you can click a cell and read a sentence, you can do this. No prior experience needed. If you're brand new to the application itself, the Excel for Beginners starter guide covers the basics worth knowing first.
|
| Your first formula doesn't need to be complex — it just needs to start with the right character. |
What You'll Be Able to Build (and the One Thing to Check First)
By the end of this guide, you'll know how to write basic arithmetic formulas, reference other cells instead of typing raw numbers, and spot when something's silently broken. Nothing exotic — just the foundation that every more advanced formula is built on.
Before you type anything, look for the formula bar. It's the long input field that runs across the top of your spreadsheet, just above the column letters. When you click a cell, that bar shows you exactly what's inside it: a number, text, or a formula. If you can see it, you're ready. This works the same way in Microsoft Excel, Microsoft 365, and Google Sheets.
A spreadsheet formula is just an instruction. You're telling Excel: "here's a calculation I want you to run, and here's where to put the result." That's it. Not magic. An instruction.
Step 1: Type the Equal Sign and Build Your First Formula from Scratch
Click any empty cell. Type a number, press Enter, and Excel stores the number. Fine. But type =2+2 and press Enter — Excel shows you 4. That's a formula. The difference is the equals sign at the front.
Why Excel Ignores Everything You Type Unless It Starts with =
The equal sign is how Excel knows you're giving it an instruction rather than entering text or a number. Without it, SUM(A1:A5) is just a string of characters. With it, =SUM(A1:A5) is a command. The equal sign is Excel's way of knowing you've switched from "storing data" mode to "do something with data" mode.
My dad showed me this on a budget spreadsheet when I was sixteen. He typed =SUM(B2:B8), hit Enter, and the total appeared instantly. I remember thinking it was a trick. It wasn't — it was just the equals sign doing its job.
Try this now:
- Click cell B1 and type 50, then press Enter.
- Click cell B2 and type 30, then press Enter.
- Click cell B3 and type =B1+B2, then press Enter.
Cell B3 should show 80. Watch the formula bar while you type — you'll see the formula appear there as you build it. That bar is your window into what Excel is actually doing. Get used to checking it.
That =B1+B2 is a formula using cell references: you're pointing Excel to specific cells rather than hardcoding numbers. Which leads directly to why that matters.
Step 2: Use Cell References to Make Your Formula Actually Useful
Once you've built a formula with cell references, changing B1 from 50 to 75 automatically updates B3. That's the payoff. A colleague of mine used to spend three hours every Friday copying numbers manually into a summary sheet. One formula reference cut that to thirty seconds. Not an exaggeration.
Relative vs. Absolute References: Which One to Use and When
Here's where most beginners hit a wall. A relative reference like B1 shifts when you copy the formula to another cell. Copy =B1+B2 from B3 to C3 and Excel adjusts it to =C1+C2 automatically. That's usually what you want.
But sometimes you need a cell to stay fixed — say, a tax rate in cell D1 that every row's formula should reference. That's an absolute reference: $D$1. The dollar signs lock the row and column so copying the formula doesn't shift it. In other words, $D$1 always means "cell D1," regardless of where the formula moves.
To lock a reference while typing, click the cell reference in the formula bar and press F4. Excel adds the dollar signs for you. For a deeper look at when each type applies, the relative vs. absolute references guide walks through several real examples.
For a basic SUM formula in Excel — like totaling a budget column — you rarely need absolute references. But skip learning them now and you'll spend an afternoon confused later. Better to know they exist.
Step 3: Check Whether Your Formula Is Actually Working
With your formula in place, the obvious next question is: how do you know it's actually calculating and not just sitting there as text?
Excel will not always tell you when something's wrong. A formula that displays as =B1+B2 instead of a result usually means the cell is formatted as Text rather than General or Number.
Fix it: select the cell, go to the Home tab, change the format to General, then press F2 and Enter to re-enter the formula.
A #VALUE! error means Excel hit something it couldn't process — often a cell that looks like a number but contains a space or text character. Excel isn't judging you. It just needs clean input to work with.
Two fast checks any time a formula behaves strangely: click the cell and read the formula bar to confirm it starts with = and references the right cells, then check the cell's number format. Those two steps resolve the majority of beginner formula problems before you need to dig further. The Excel formulas and functions beginner guide covers the broader diagnostic landscape if you're troubleshooting something more stubborn.
Common Mistakes When Creating Excel Formulas (and How to Stop Making Them)
I used to make all three of these. Still catch myself on the third one occasionally.
| Mistake | What Happens | The Fix |
|---|---|---|
| Forgetting the equal sign | Excel stores the entry as plain text and displays it as-is — no error, no calculation | Always start with = |
| Copying without locking references | Formula works in one cell but returns wrong results or errors after copying down | Use $ on any reference that should stay fixed |
| Order-of-operations surprises | =2+3*4 returns 14, not 20 — multiplication runs before addition |
Use parentheses: =(2+3)*4 returns 20 |
| Invisible trailing spaces in data | A cell that looks like "Chicago" may contain "Chicago " — formulas that match or reference it can silently fail | Use =TRIM() to strip hidden spaces |
That last one is worth calling out. I've seen it derail someone who followed a tutorial exactly and still got errors. His conclusion was that he wasn't "an Excel person." He was wrong. The data had trailing spaces. =TRIM() fixed it in under a minute.
Frequently Asked Questions
Why is my Excel formula showing as text and not calculating?
The most common cause is that the cell is formatted as Text. Select the cell, change the format to General on the Home tab, then press F2 and Enter to force Excel to re-read the formula. Also confirm the formula starts with an equals sign — without it, Excel treats the entire entry as a text string.
What is the difference between absolute and relative cell references?
A relative reference like B2 adjusts automatically when you copy a formula to another cell. An absolute reference like $B$2 stays locked on that exact cell no matter where you copy the formula. Use absolute references when part of your formula should always point to the same cell — a tax rate, a fixed total, or a lookup table header.
How do I know if my Excel formula has an error?
Visible errors like #VALUE! or #REF! are the easy ones — Excel is telling you something broke. The harder cases are silent errors, where the formula calculates but gives the wrong result. Get into the habit of clicking your formula cell and reading the formula bar to confirm it's referencing the right cells, and check that the cell format isn't set to Text.
If you take one thing from this article: every formula starts with =, references cells instead of hardcoding numbers wherever possible, and can be checked instantly by reading the formula bar. Start there. Everything else — IF statements, VLOOKUP, nested logic — builds on exactly that foundation. In 2026, those tools are more accessible than they've ever been, and this is the right place to start.
Join the conversation