|
The
Intermediate Guide to Microsoft Excel 2010 demonstrated a dozen
or so essential formulas. Many
spreadsheets use recursive or very complicated math functions, such
as computing energy or figuring 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.
Consdier This: The Order of Operation (E)
Exponents (or Powers) (M)
Multiplication (D)
Division (A)
Addition (S)
Subtraction Keep
going...
Formulas ->Formula Auditing
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.2. Enforce precedence: Precedence
of operators
|
|
| |
