Basic Formulas and Operators in MS Excel
Master Automatic Calculations, Mathematical Operators, Cell References, Order of Operations, Parentheses, and Practical Expense Sheets
1. What is an Excel Formula?
A formula is an instruction used to perform calculations in Excel. A formula can contain numbers, cell references, mathematical operators, and functions.
For example, type =10+20 in a cell and press Enter. Excel displays the result 30.
2. Using Cell References in Formulas
Instead of typing numbers directly, you can use cell references. Excel calculates using the values stored in those cells.
| Cell | Value |
|---|---|
| A1 | 100 |
| B1 | 50 |
Enter =A1+B1 in cell C1. Excel displays 150.
3. Basic Mathematical Operators
| Operator | Meaning | Example | Result |
|---|---|---|---|
| + | Addition | =10+5 | 15 |
| - | Subtraction | =10-5 | 5 |
| * | Multiplication | =10*5 | 50 |
| / | Division | =10/5 | 2 |
| ^ | Power | =2^3 | 8 |
| % | Percentage | =50*10% | 5 |
4. Addition Formula
The plus sign (+) adds values.
Example: If A1 contains 100 and B1 contains 200, enter:
Result: 300
5. Subtraction Formula
The minus sign (-) subtracts one value from another.
If A1 is 500 and B1 is 150, the result is 350.
6. Multiplication Formula
The asterisk (*) is used for multiplication in Excel.
If A1 is 20 and B1 is 5, the result is 100.
7. Division Formula
The forward slash (/) divides one value by another.
If A1 is 100 and B1 is 4, the result is 25.
Note: Dividing by zero causes a #DIV/0! error.
8. Percentage Formula
To calculate a percentage, divide the obtained value by the total value and format the result as a percentage.
Formula: =400/500
Result: 0.8, or 80% when formatted as Percentage.
9. Order of Operations
Excel follows the mathematical order of operations. Multiplication and division are performed before addition and subtraction unless parentheses change the order.
| Formula | Result | Explanation |
|---|---|---|
| =10+5*2 | 20 | 5 × 2 first, then add 10 |
| =(10+5)*2 | 30 | Parentheses first, then multiply |
10. Using Parentheses
Parentheses help control the order of calculations.
For example, =(A1+B1)*C1 adds A1 and B1 first, then multiplies the result by C1.
11. Practical Exercise
Create the following expense sheet in Excel:
| Item | Quantity | Price | Total |
|---|---|---|---|
| Notebook | 5 | 100 | 500 |
| Pen | 10 | 20 | 200 |
| File | 4 | 50 | 200 |
- Enter the headings in cells A1:D1.
- Enter the items and their quantities and prices.
- In D2, enter =B2*C2.
- Copy the formula down to D3 and D4.
- In D5, enter =D2+D3+D4 to calculate the total expense.
- Save the file as Basic Formulas Practice.xlsx.
12. Lesson Summary
- Excel formulas begin with =.
- + adds, - subtracts, * multiplies, and / divides.
- ^ calculates powers and % represents percentages.
- Cell references can be used instead of typing numbers.
- Parentheses control the order of calculations.
13. Test Your Knowledge – Interactive MCQs
Enter your name and select your answers. Each answer locks immediately with instant feedback.
Basic Formulas and Operators – Online MCQ Test
10 Questions | 10 Marks | One-Time Selection
Final Test Result
Congratulations! You have completed Lesson 38. Continue to Lesson 39 to advance further in your Excel diploma program.
© Social Media Point | Free Digital Education
