Calculating formulas in tables
WordPerfect lets you perform spreadsheet calculations on table data. For example, you can calculate formulas, add values in a table quickly, and ignore a cell during calculations.
Formulas are calculated automatically each time you move the insertion point or insert a formula using the Table formula toolbar. You can disable automatic calculation.
You can also fill in cells with incrementing patterns and dates. A pattern of values must increment or decrement based on addition or subtraction. You cannot fill in a pattern of values that increment or decrement based on multiplication or division.
You can get more information about table formula errors, including a brief explanation of any ?? and ERR error symbols that display in a table as you calculate formulas.
To calculate a formula in a table |  |
|
1.
|
|
Click in a table.
|
|
2.
|
|
Click Table
 Calculate. |
|
3.
|
|
Enable one of the following options:
|
|
•
|
Calculate table — calculates the table or floating cell in which the insertion point is positioned
|
|
•
|
Calculate tables in document — calculates all tables and floating cells in the document
|
|
•
|
|
You can disable automatic calculation by enabling the Off option.
|
To add values in a table quickly | |
|
1.
|
|
Click the table cell below or to the right of the cells whose total you want to calculate.
|
|
2.
|
|
Click Table
QuickSum. |
|
•
|
|
The calculated sum overwrites any values, formulas, or text in the cell you click.
|
|
•
|
|
You can also add values by clicking the QuickSum button on the Table formula toolbar. To display the Table formula toolbar, click Table
Formula toolbar. |
To ignore a table cell during calculations | |
|
1.
|
|
Select a cell, and click Table
Format. |
|
2.
|
|
Click the Cell tab.
|
|
3.
|
|
Enable the Ignore cell when calculating check box.
|
To fill a table with incremental numbers or dates | |
|
1.
|
|
Select the cells that contain the incremental or decremental pattern of val
ues as well as the cells in which you want to continue the pattern. |
|
2.
|
|
Click Table
QuickFill. |
|
•
|
|
You can also fill a table with incrementing numbers or dates by clicking the QuickFill button on the Table formula toolbar. To display the Table formula toolbar, click Table
Formula toolbar. |
To display more information about table formula errors | |
|
1.
|
|
Click a cell that contains an error.
|
|
2.
|
|
Click the View error button on the Table formula toolbar.
|