Simple formulas are mathematical expressions with one operator, such as 7+9. A complex formula has multiple mathematical operators, such as 5+2*8. When there are multiple operations in a formula, the order of operations tells your spreadsheet which operation to evaluate first. In order to use complex formulas, you need to know the order of operations.
Watch the video below to learn more about complex formulas.
Operation sequence of excel complex formula tutorial
All excel spreadsheet programs calculate formulas according to the following sequence of operations:
- Operations inside parentheses
- Exponential calculation (eg 3^2)
- Multiplication and division, whichever comes first
- Addition and subtraction, whichever comes first
Related:cheap office key