Arithmetic operators
Basic math in Excel uses special symbols called operators.
Main operators
+ add, - subtract, * multiply, / divide, ^ power. For example: =A2+B2, =A2*B2, =A2^B2.
Percent
The % sign divides a number by 100: =B2*10% is 10 percent of B2 — the same as =B2*0.1.
Comparison operators
=, >, <, >=, <=, <> (not equal) return TRUE or FALSE. They’re often used inside IF: =IF(B2>=60, ...).
Tips
- Dividing by zero gives
#DIV/0!— check the divisor cell. - Use
&to join text:=A2&" "&B2.
Try it in the simulator
Type the matching operations into D2:D6: =A2+B2, =A3-B3, =A4*B4, =A5/B5 and =A6^B6.
Книга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 | Operation | Result | ||||||||||||||||||||
| 2 | 12 | 4 | Addition | |||||||||||||||||||||
| 3 | 12 | 4 | Subtraction | |||||||||||||||||||||
| 4 | 12 | 4 | Multiplication | |||||||||||||||||||||
| 5 | 12 | 4 | Division | |||||||||||||||||||||
| 6 | 2 | 3 | Power | |||||||||||||||||||||
| 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