Mathematical Operators are +,-,*,/^ respectively addition, subtraction, multiplication, division and orders (aka powers, indices)
Mathematics dictates theOrder 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