In Excel complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.
Knowing the order of operations is essential to getting the correct answer. Spend some time memorizing it:
1. Operations enclosed in parentheses
2. Exponential calculations (to the power of)
3. Multiplication and division, whichever comes first
4. Addition and subtraction, whichever comes first