More Formulas, More Options



Example of a formula we created earlier in Microsoft Excel

Extra for Experts: Formulas

The Intermediate Guide to Microsoft Excel demonstrated a dozen or so essential formulas. Many spreadsheets use nested, recursive or very complicated math functions. One example would be the formulas that are needed to compute energy or figure out the cost per unit of an area or volume.

You may have wondered what can you do to make sure the math is right.


PEMDAS is an acronym that was invented to help folks remember the Oder of Operations. All equations follow PEMDAS, no matter how complex or simple the formula may be.


1. Consider This: The Order of Operation
(P) Parentheses, first

(E) Exponents (or Powers)

(M) Multiplication

(D) Division

(A) Addition

(S) Subtraction


Keep going...