Highline Excel 2013 Class Video 03


Order of Precedence in Excel

DESCRIPTION

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

WORKBOOKS