Administration and Executive AssistantTier 145 minbeginner

Operator Precedence and Parentheses

Master the order of operations so your formulas calculate what you intended.

What you will learn

• Understand PEMDAS in Excel context
• Know when parentheses are required vs. helpful
• Recognize precedence errors by reading the result
• Use nested parentheses safely

Excel skills

Operator precedence, formula evaluation · Formula Evaluation Order

The task

Fifteen quotes need pricing before the client meeting this afternoon. The rule is: take the cost times quantity, add our markup, then take the client's negotiated discount off the marked-up figure. In that order. Discount comes off the marked-up price, not the raw cost.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free