Anatomy of a formula
Every Excel formula starts with =. After that comes any combination of values, cell references, operators, and function calls — for example =SUM(A1:A10) * 2. Excel evaluates the formula and shows the result in the cell, while the formula itself stays visible in the formula bar.
Cell references
A1 refers to the cell at column A, row 1. A1:A10 is a range. Sheet2!A1 is a cell on another sheet. [Workbook.xlsx]Sheet1!A1 refers to another workbook. References update automatically when you insert or delete rows and columns — which is usually what you want, and occasionally what breaks a model.
Absolute vs relative references
A1 is relative — drag the formula down and it becomes A2, A3, and so on. $A$1 is absolute and stays put. $A1 locks the column; A$1 locks the row. Mixed references are the secret to building one formula that fills a whole grid — common in tax tables and multiplication-style layouts.
Operators and order of operations
Arithmetic operators: + - * / ^ %. Comparison: = <> < > <= >=. Text concatenation: &. Reference: : (range), , (union), space (intersection). Excel follows standard mathematical precedence: parentheses first, then exponents, then multiplication and division, then addition and subtraction. When in doubt, add parentheses.
Functions
A function is a named operation that takes arguments and returns a value: SUM(range), IF(test, then, else), VLOOKUP(lookup, table, col, exact). Functions can be nested — the result of one becomes an argument to another: =IF(SUM(A1:A10)>0, "Positive", "Empty"). Excel evaluates from the inside out.
Recalculation
By default, Excel recalculates the whole dependency graph whenever any input changes. For large models you can switch to manual calculation (Formulas → Calculation Options) and press F9 to recalc on demand.
Excel Tools
Free Excel and spreadsheet tools — formula helpers, converters, and data cleaners.
Open Excel ToolsFrequently asked questions
More Excel Tools guides
What Is Microsoft Excel?
A friendly introduction to Microsoft Excel: what the app does, where it shines, and why it's still the world's default spreadsheet.
Read articleExcel vs Google Sheets
Excel and Google Sheets do 90% of the same things — but the last 10% matters. Here's how they compare on formulas, collaboration, performance, and price.
Read articleThe Most Useful Excel Functions
Learn these ten Excel functions and you'll handle 90% of everyday spreadsheet work. Examples, syntax, and when to reach for each one.
Read articleCommon Excel Errors and How to Fix Them
Decode Excel's six most common formula errors and learn the quickest way to fix each one — without rewriting your whole spreadsheet.
Read articleExcel for Beginners
Start here if Excel feels intimidating: the core concepts and habits that unlock everything else.
Read articleHow to Use VLOOKUP
The classic lookup function, demystified — with the gotchas that trip up most people.
Read articleHow to Use XLOOKUP
The newer, smarter lookup — and why it's worth switching from VLOOKUP whenever you can.
Read articleBest Excel Functions for Work
If you only learn a handful of Excel functions, learn these. They cover most real-world office tasks.
Read articleExcel Productivity Tips
The shortcuts and habits that separate slow Excel users from fast ones.
Read article