Formulas: Calculation Order of Precedence

Topics: Formula Elements, Formula Types and Cell References, Assumption Tables/Formula Elements, and Scenario Manager

 

 

Topics in this video:
Parenthesis ( )
Reference Operators: colon, space, comma
Example of colon in range of cells
Example of intersection operator
Example of comma (union
Negation
Converts %
Exponents
Multiplication (*) and Division (/), left to right
Adding (+) and Subtracting (-), left to right
Ampersand (&) (Join operator)
Comparative operators

Questions