Tips and Tricks

Posted inTraining

Tips for calculating in a Table

Example:

=A1+B1 to add

=A1-B1 to subtract

= A1*B1 to multiply

=A1/B1 to divide

Operators are:

Addition  (+)  Subtraction  (-)
Multiplication  (*)   Division (/)

  1. Click in the answer cell.
  2. Table Tools Contextual Tabs > Layout Tab > Formula.
  3. Enter formula or view automatic formula.
  4. F9 function key updates calculations (select the table first).

Alt+F9 displays formula field and toggles the field off again