Basic Formula Syntax
Basic Formula Syntax
Turning your Spreadsheet into a Powerful Calculator
A Formula is an equation that performs a calculation. Unlike a standard calculator where you type numbers, Excel formulas use Cell References so that your results stay accurate even if your data changes.
The Golden Rule: Start with =
If you don't type the Equal Sign first, Excel treats your formula as plain text!
Standard Math Operators
| Operation | Operator | Example | Result |
|---|---|---|---|
| Addition | + | =A1+B1 | Adds values |
| Subtraction | - | =A1-B1 | Subtracts values |
| Multiplication | * | =A2*B2 | Multiplies values |
| Division | / | =C2/D2 | Divides values |
🧠 The "Parentheses" Power
Excel follows math rules (BODMAS/PEMDAS). It does multiplication before addition.
Example: =(C2+D2)/2
Using brackets forces Excel to add the numbers first before dividing them to find the average.
🔄 Automatic Updates
This is the best part! If your formula is =A1+B1 and you change the number in A1, the total updates instantly. You never have to rewrite the formula.
💡 Skill Eco Pro-Tip: Point-and-Click
When writing a formula, you don't have to type "A1". Just type =, then click on cell A1 with your mouse. Excel will type the reference for you. This prevents typos!
🏋️ Test Yourself With Exercises
Take our quiz on Basic Formula Syntax to test your knowledge.
Exercise »