3  Intro to Formulas

3.1 What is an Excel formula?

Excel “formulas” automatically calculate the value in one cell based on the values that appear in other cells. See below for more info…

3.2 Numeric Operators ie. + - * / ^

3.3 Errors in formulas

3.4 Order of operations

3.5 “Formulas View” vs “Values View”

• press ctrl-` (win) or cmd-` (mac) to “toggle” (i.e. switch between) “formulas view” and “values view”
  (NOTE - the ` key is usually found under the ESC key. The ` symbol is usually found on the same key as the tilde ie. ~)