Explanation
A formula is an expression used in Excel to perform calculations. A formula can contain numbers, cell references, operators, and functions.
Every Excel formula starts with an equal sign (=).
Basic Examples
=10+20
=A2+B2
=B2*C2
=C2/D2
Example
Create the following worksheet:
|
Product |
Quantity |
Price |
Total |
|
Pen |
10 |
20 |
|
|
Notebook |
5 |
50 |
|
|
File |
8 |
40 |
|
|
Folder |
6 |
60 |
In cell D2, enter:
=B2*C2
Press Enter and copy the formula down.
Result
|
Product |
Quantity |
Price |
Total |
|
Pen |
10 |
20 |
200 |
|
Notebook |
5 |
50 |
250 |
|
File |
8 |
40 |
320 |
|
Folder |
6 |
60 |
360 |
Key Points
- A formula starts with =.
- Formulas can use cell references.
- Excel automatically calculates the result.
- When source data changes, the formula result can update automatically.
Practice
Create a Student Marks Sheet with:
|
Student |
English |
Maths |
Science |
Total |
|
Amit |
78 |
85 |
72 |
|
|
Neha |
82 |
91 |
88 |
|
|
Rahul |
65 |
74 |
70 |
Calculate Total Marks using a formula.