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 (/)
- Click in the answer cell.
- Table Tools Contextual Tabs > Layout Tab > Formula.
- Enter formula or view automatic formula.
- F9 function key updates calculations (select the table first).
Alt+F9 displays formula field and toggles the field off again