Formulas
Formulas are the heart of Excel. They calculate results from cell values and update themselves when those values change.
Your first formula
In the shop table, total = quantity × price. Type =B2*C2 into D2 and you get 3 × 4000 = 12000.
Automatic recalculation
Change B2 to 5 and D2 becomes 20000 immediately. No manual recalculation needed.
Viewing and editing
The cell shows the result; the formula bar shows the formula. Press F2 or click the formula bar to edit. Ctrl+ shows all formulas.
Example
Formula:
=B2*C2→ result: 12000
Tips
- Don’t type numbers into formulas (
=3*4000) — reference cells (=B2*C2) or the result won’t update. - If a formula shows an error (#VALUE!, #DIV/0!), check the cells it refers to.
Try it in the simulator
Type =B2*C2 into D2 and fill it down to D5. Then change the number in B2.
Книга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 | Product | Qty | Price | Total | ||||||||||||||||||||
| 2 | Bread | 3 | 4000 | |||||||||||||||||||||
| 3 | Milk | 2 | 12000 | |||||||||||||||||||||
| 4 | Eggs | 10 | 1500 | |||||||||||||||||||||
| 5 | Tea | 1 | 25000 | |||||||||||||||||||||
| 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