answersLogoWhite

0

That's more or less the same as in most programming languages, and similar to the precedence used in algebra. Specifically:

  • First, calculate all powers from left to right.
  • Next, calculate all multiplications and divisions from left to right.
  • Next, calculate all additions and subtractions from left to right.

The order of evaluation can be changed with parentheses; thus, for example:

1 + 2 * 3 = 7

(1 + 2) * 3 = 9

User Avatar

Wiki User

11y ago

Still curious? Ask our experts.

Chat with our AI personalities

CoachCoach
Success isn't just about winning—it's about vision, patience, and playing the long game.
Chat with Coach
LaoLao
The path is yours to walk; I am only here to hold up a mirror.
Chat with Lao
BeauBeau
You're doing better than you think!
Chat with Beau

Add your answer:

Earn +20 pts
Q: What is the order of precedence in Excel 2010?
Write your answer...
Submit
Still have questions?
magnify glass
imp