Topic 14 – Notes
CREATE BASIC FORMULAS
After completing this lesson, you should know:
- How to enter a formula in a cell
- How to refer to other cells when creating a formula
- What the order of operations in Excel is
Enter a Formula in a Cell
Excel is like a giant calculator. To let Excel know that you want to use a formula, start with an equal sign (=).
The basic operators are:
- Addition (+)
- Subtraction (-)
- Multiplication (*)
- Division (/)
To change anything in the formula, double-click on the cell and edit.
Refer to Other Cells when Creating a Formula
Instead of typing the values you want to use in your calculations, you can also refer to other cells when entering a formula.
The Order of Operations in Excel
If you use more than one operator in one formula, you need to keep the order or operations in mind.
B → Brackets
O → Of (fraction)
D → Division
M → Multiplication
A → Addition
S → Subtraction
Type this formula in a cell. The answer will be 11.
We need the answer to be 21 for this example. Excel will follow the correct order of operations (BODMAS). Multiplication is before Addition and therefore Excel will first calculate 2*3 (=6) and then add 5 (=11).
To change this so that 5+2 is calculated first, we should add brackets, because Excel will always calculate the brackets first according to BODMAS.