202R1/2 Complex Maths for Spreadsheets (introduction)

The order of operations

Excel calculates formulas based on the following order of operations:

1. Operations enclosed in parentheses
2. Exponential calculations (3^2, for example)
3. Multiplication and division, whichever comes first
4. Addition and subtraction, whichever comes first

A mnemonic that can help you remember the order is PEMDAS, or Please Excuse My Dear Aunt Sally.

NOTE

there are a few variations between Excel and other spreadsheets on the spelling of the function

Backup (Sabrosa)