Explanation
Arithmetic operators are used to perform mathematical calculations in Excel.
|
Operator |
Meaning |
Example |
|
+ |
Addition |
=A2+B2 |
|
– |
Subtraction |
=A2-B2 |
|
* |
Multiplication |
=A2*B2 |
|
/ |
Division |
=A2/B2 |
|
% |
Percentage |
=A2*10% |
|
^ |
Power |
=A2^2 |
Example Table
|
A |
B |
Formula |
Result |
|
20 |
10 |
=A2+B2 |
30 |
|
20 |
10 |
=A3-B3 |
10 |
|
20 |
10 |
=A4*B4 |
200 |
|
20 |
10 |
=A5/B5 |
2 |
|
200 |
=A6*10% |
20 |
|
|
5 |
2 |
=A7^B7 |
25 |
Practical Example
Suppose:
- Quantity = 15
- Price = ₹50
Formula:
=B2*C2
Result:
₹750
Practice
Create a calculator worksheet and perform:
- Addition
- Subtraction
- Multiplication
- Division
- Percentage
- Power