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...
