Formula syntax
A formula is an expression that tells Excel what to calculate. It always starts with an = sign.
The = sign
As soon as you type = into a cell, Excel treats what follows as a formula. Without =, A2+B2 is just text.
References
Use cell addresses in formulas, not numbers: =A2+B2. Then if A2 or B2 changes, the result updates automatically.
Parts of a formula
A formula can contain references (A2), numbers (10), operators (+ - * /) and functions (SUM). For example: =SUM(A2:A3)*2.
Example
Formula:
=A2+B2→ result: 15
Tips
- While typing a formula, click a cell — its reference is inserted for you.
- If you see the formula text instead of a result, the = is missing or the cell is formatted as text.
Try it in the simulator
Type =A2+B2 into C2 and press Enter. Then change the number in A2 and watch C2 update.
Книга1 - Excel
—☐✕
Буфер обмена
Calibri ▾11 ▾
Шрифт
Выравнивание
Общий ▾
Число
Стили
Ячейки
Редактирование
✕✓fx
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | A | B | Result | |||||||||||||||||||||
| 2 | 5 | 10 | ||||||||||||||||||||||
| 3 | 8 | 4 | ||||||||||||||||||||||
| 4 | ||||||||||||||||||||||||
| 5 | ||||||||||||||||||||||||
| 6 | ||||||||||||||||||||||||
| 7 | ||||||||||||||||||||||||
| 8 | ||||||||||||||||||||||||
| 9 | ||||||||||||||||||||||||
| 10 |
Лист1
Готово
−+100%
Test your knowledge
Do graded exercises on these topics in the “Practice” section and earn coins.
Go to exercises