Top Navigational Bar

Tables - Formulas Not Calculating Due To Cell
DocumentID: 600799
Revision Date: 29-Feb-96 1:28:31 PM

The information in this document applies to:
WordPerfect® 5.1 for DOS

Problem

Symptoms: A customer has a table with math formulas in it. When the formulas are calculated the customer receives an unusually large number (936,313.50). Another customer had a similar problem, only the math calculation was off by one. Solutions: The usual cause for higher numbers is that the user is not setting cells that have text in them as text cells. After customers format all header rows and cell labels as text cells, the numbers calculate correctly. The default type of cells is numeric.

In a WordPerfect 5.1 table if there is a math calculation (subtotal, formula, etc.) in a cell, the calculation will appear at the bottom right corner of the screen as = +, = A1+B1, etc. If the cell is changed to be a text (rather than a numeric) cell, the calculation then appears as " +, " A1+B1, etc., in the lower right corner. Those cells will no longer be calculated when a re-calculation is done on the table. Also, if a Total (=) is below a Subtotal (+) that has been designated as a numeric cell, the Total will come up as ??.

Another way to determine if the Cell Type is Numeric or Text is by the first character in front of the formula. If the character is a quote ("), the Cell Type is Text. If the character is an equal sign (=), the Cell Type is Numeric.

A customer attached footnotes to some text in her table. She also used Math to subtotal a column in her table. Math looked at the footnote numbers and added them into the subtotal. She formatted the cells as text (in Table Edit: 2, 1, 1, 2), and recalculated, and then everything was fine. This is working as designed.

Answer:

Details:


Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER.