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 (/)

Examples:







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.

 

Examples:






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

 

Example:

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.









Exit
Last modified: Friday, 30 April 2021, 3:22 PM