Using The Calculation Editor
-
Select the cell you want to modify.
-
On the Home tab, click Cell.
-
Under Calculation Properties, click the to launch the Calculation Editor.
- Select the Functions, Variables, or Database tab for the information you want to enter.
- Select the category of function, variable or database you want to enter. The members of that category will be displayed in the middle window.
- Select one of the items displayed in the middle window. A definition of that function, variable or database will be displayed in the window to the right.
- Double-click a function, variable or database to insert the calculation.
- Click applicable operator keys to build the calculation as you would on a physical calculator.
- Continue switching between the calculation tabs as necessary to build the calculation.
- Click OK when you are done.