Location: Edit Template

You can type a formula directly in a cell or on the formula row above the workbook table, or create it by selecting a function from a list.

1.Click . A dialogue box listing the available functions opens.

2.Select a function category from the list on the left and a function from the list on the right. Double-click the function to add it to the Formula field.

3.Do one of the following:

•Complete the formula in the Formula field and click OK to add it to the workbook. Go to step 5 unless you want to edit the formula in the workbook view.

•Leave the formula uncompleted and click OK, then continue to the next step for completing the formula in the workbook view.

4.To enter cell references to a formula, you can type them directly on the formula row or select the cells in the workbook. Remember to add a comma between the cell references.

5.When finished, press ENTER.

If you want to edit a value in the formula, click on the formula in the formula row and then click a link in the pop-up window that appears. The corresponding value is highlighted on the formula row and you can make the required changes to it.

To check the validity of the formula, click .

To reset the value, click .

Note! Formulas in hidden rows or columns can only be modified in Excel, because rows and columns cannot be unhidden in Input and Report Templates.