Microsoft Excel is one of
the most powerful spreadsheet applications used by students, teachers, office
workers, accountants, and business professionals worldwide. One of its greatest
strengths is the ability to perform calculations automatically using formulas.
Whether you want to
calculate marks, monthly expenses, business profits, or scientific data,
learning how to create formulas is the first and most important step toward
mastering Microsoft Excel.
In this beginner-friendly guide, you will learn how Excel formulas work, how to create them correctly, and how to avoid common mistakes.
If you are new to Excel, I recommend reading our Introduction to MS Excel before learning formulas. It explains the Excel interface, worksheets, rows, columns, and basic navigation.
What
Is a Formula in MS Excel?
A formula is an equation
entered into a worksheet that performs calculations automatically.
Every Excel formula always
begins with an equal sign (=).
For example:
►=10+20
►=A1+B1
►=B2*C2
When you press Enter,
Excel instantly calculates the result.
Why
Learn Excel Formulas?
Learning formulas helps
you:
►Save time on calculations.
►Reduce human errors.
►Automatically update results when values
change.
►Improve productivity.
►Build a strong foundation for advanced Excel
functions.
Whether you are a student or an office professional, formulas make your work easier and more accurate.
Formulas become even more useful when your worksheet is well organized.
After learning formulas, you can improve your productivity with our guide on Top 7 Excel Tricks to Work Smarter.
Understanding
Cell References
Every cell in Excel has a
unique address.
Examples include:
►A1
►B3
►C7
►D10
Instead of typing numbers
directly into formulas, Excel allows you to use cell references.
Example:
Suppose:
►A1 = 15
►B1 = 25
Formula:
=A1+B1
Result:
40
If either value changes,
Excel automatically updates the answer.
Basic
Mathematical Operators
Excel uses the following
operators:
|
Operator |
Meaning |
Example |
|
+ |
Addition |
=A1+B1 |
|
- |
Subtraction |
=A1-B1 |
|
* |
Multiplication |
=A1*B1 |
|
/ |
Division |
=A1/B1 |
|
^ |
Power |
=A1^2 |
Creating
Your First Formula
Let's create a simple
addition formula.
Step
1
Enter:
15 in cell A1
25 in cell B1
Step
2
Click cell C1.
Step
3
Type:
=A1+B1
Step
4
Press Enter.
Excel displays:
40
Congratulations! You have
created your first Excel formula.
Example
1 – Addition
|
Item |
Value |
|
A1 |
120 |
|
B1 |
80 |
Formula:
=A1+B1
Result:
200
Example
2 – Subtraction
Suppose:
Income = 5000
Expenses = 3200
Formula:
=A1-B1
Result:
1800
Example
3 – Multiplication
Suppose:
Quantity = 15
Price = 80
Formula:
=A1*B1
Result:
1200
Example
4 – Division
Suppose:
Total Marks = 450
Subjects = 5
Formula:
=A1/B1
Result:
90
Formula
Bar
The Formula Bar is located
above the worksheet.
It displays the formula
stored in the selected cell.
Although a worksheet cell
shows the calculated result, the Formula Bar shows the actual formula.
Editing
a Formula
To edit a formula:
1.
Click the cell.
2.
Press F2 or click inside the
Formula Bar.
3.
Make the required changes.
4.
Press Enter.
Common
Mistakes Beginners Make
Avoid these common errors:
Forgetting
the Equal Sign
Incorrect:
A1+B1
Correct:
=A1+B1
Typing
Cell Names Incorrectly
Incorrect:
=A+B
Correct:
=A1+B1
Dividing
by Zero
Example:
=A1/B1
If B1 contains zero, Excel
displays:
#DIV/0!
Using
Spaces Incorrectly
Always type formulas
carefully without unnecessary spaces.
Practical
Exercise
Create the following
worksheet:
|
Student |
Marks |
|
English |
75 |
|
Mathematics |
88 |
|
Science |
81 |
|
Computer |
92 |
Now calculate:
►Total Marks
►Average Marks
►Highest Marks (after learning functions)
Once you have entered your data and created formulas, the next step is learning how to organize your worksheet efficiently using Excel's Sorting and Filtering Features.
Tips
for Writing Better Formulas
►Always begin with =
►Use cell references instead of typing numbers
repeatedly.
►Double-check brackets when formulas become
longer.
►Keep your worksheet organized.
►Save your work regularly.
Frequently
Asked Questions
What
is the first symbol used in every Excel formula?
Every formula begins with
an equal sign (=).
Can
formulas update automatically?
Yes.
Whenever the value of a
referenced cell changes, Excel automatically recalculates the result.
What
is a cell reference?
A cell reference is the
address of a worksheet cell, such as A1, B5, or C10.
Why
should I use formulas instead of a calculator?
Excel formulas save time, reduce errors, and update calculations automatically.
After mastering formulas, you should also learn how to create clean and accurate worksheets. Our guide on Data Cleaning in Excel will help you remove errors and prepare professional spreadsheets.
Conclusion
Creating formulas is one of
the most important skills every Microsoft Excel user should learn. Once you
understand how formulas work, you can perform calculations quickly and
accurately without repeating manual work.
Practice simple formulas
every day until they become natural. As your confidence grows, you can move on
to learning Excel functions such as SUM, AVERAGE, IF,
and COUNT, which make Excel even more powerful.
With regular practice, you
will soon be able to create professional worksheets for school, office work,
and personal projects.
0 Comments