What Is a Formula in Excel
What is a formula in Excel? Learn how formulas differ from functions, how cell references and operators work, and build a calculation with SUM, AVERAGE, and IF.
Introduction
If you are new to spreadsheets, the word 'formula' is the one concept that unlocks everything else. A formula is simply an instruction that starts with an equals sign and tells Excel to calculate something. This guide explains what formulas are, how they work, and the three you will use most.
Prerequisites
- Excel or Google Sheets open in front of you
- No prior spreadsheet experience needed
1Formula or Function - What's the Difference
A formula is any expression you type that begins with = and calculates a result. A function (like SUM or AVERAGE) is a built-in, named operation you call inside a formula. Most formulas you write will use one or more functions, but a formula does not have to.
Example
=A1+A2This is a formula but not a function; it uses only the + operator.
Every formula, with or without a function, must start with = or Excel treats the entry as text.
2The Anatomy of an Excel Formula
A formula is built from values, cell references, operators, and functions. Excel evaluates it following operator precedence, then shows the result in the cell while the actual formula lives in the formula bar above the grid.
Example
=SUM(A1:A5)*0.1Functions nest inside formulas - here SUM feeds the * operator.
Press F2 to edit a formula, F4 to toggle absolute references while editing.
3Operators You Can Use
Excel supports arithmetic (+, -, *, /, ^), comparison (=, >, <), and text joining (&). Comparison operators return TRUE or FALSE and are what power logical functions such as IF.
Example
=B1>C1A comparison produces a logical TRUE/FALSE value you can feed straight into IF.
Use & (not +) to join text: ="Total: "&D10.
4Why Cell References Beat Typed Numbers
Referencing a cell (=A1*2) instead of hard-coding a value (=5*2) means your formula updates automatically when the source data changes. This single habit - pointing at cells rather than retyping numbers - is what makes spreadsheets powerful.
Example
=A1*1.2Change A1 and the result recalculates instantly - no formula edits required.
Prefer referencing an input cell over repeating the same number across many formulas.
5Three Formulas Every Beginner Should Know
SUM totals a range, AVERAGE finds the mean, and IF branches on a test. Together they cover the majority of everyday spreadsheet tasks, and each one is a building block for more advanced work.
Example
=IF(A1>=60, "Pass", "Fail")IF(logical_test, value_if_true, value_if_false) is the gateway to all conditional logic.
Once IF clicks, explore IFS and nested IF for handling multiple conditions at once.
Functions Used
Related Guides
Absolute vs Relative Reference
Absolute vs relative reference in Excel explained: what $ really locks, when to use mixed refs, the F4 shortcut, and dynamic alternatives in Google Sheets.
Master Excel Dynamic Arrays (Excel 365)
Learn how to use modern dynamic array functions like FILTER, SORT, UNIQUE, and SEQUENCE to transform your spreadsheets.
Nested If Alternatives
Long nested IF formulas are hard to read and easy to break. Discover the best nested IF alternatives in Excel and Google Sheets — IFS, lookup tables, and XLOOKUP.
Summary
A formula is any = expression that calculates a result; a function is a named operation you call inside it. Formulas combine values, cell references, and operators, and referencing cells - rather than typed numbers - is what keeps your sheet dynamic. Start with SUM, AVERAGE, and IF and you can handle most everyday tasks.
Next Steps
- Open a sheet and try =SUM(A1:A10) on a column of numbers
- Read the absolute vs relative reference guide before copying formulas down
- Move on to nested IF and IFS once a single IF feels comfortable