You may have experience working with formulas that contain only one operator, such as 7+9. More complex formulas can contain several mathematical operators, such as 5+2*8. When there’s more than one operation in a formula, the order of operations tells Excel which operation to calculate first. To write formulas that will give you the correct answer, you’ll need to understand the order of operations.

Optional: Download our practice workbook. <–Click Here

Watch the video below to learn more about complex formulas.