Excel Formulas & Functions For Dummies, 6th Edition
Book image
Explore Book Buy On Amazon
Mathematics dictates a protocol of how formulas are interpreted, and Excel follows that protocol. The following is the order in which mathematical operators and syntax are applied both in Excel and in general mathematics. You can remember this order by memorizing the mnemonic phrase, "Please excuse my dear aunt Sally."

  1. Parentheses

  2. Exponents

  3. Multiplication and division

  4. Addition and subtraction

About This Article

This article is from the book:

About the book author:

Ken Bluttman is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. His latest projects include large-scale cloud-based applications and mobile app development.

This article can be found in the category: