Order of Operations
Summary:
- Mathematical Operators are +,-,*,/^ respectively addition, subtraction, multiplication, division and orders (aka powers, indices)
- Mathematics dictates the Order of Operations that Excel implements, and if this is new to you, then there is simple way to remember the order - Calculate from left to right, and apply BODMAS (Brackets, Orders, Division, Multiplication, Addition, Subtraction - from left to right in this list is what the priority order of calculation is)
- Use brackets to achieve any desired calculational result
- Nesting brackets means the inner most nested set is calculated first - this applies to everything, including nesting functions as will be seen later
0 comments