Top Navigational Bar

Table/Fix A Cell
DocumentID: 663787
Revision Date: 29-Feb-96 8:49:40 PM

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

Problem

Symptoms: Customer wants to "fix" a cell with a formula so that if the amount of the calculation is 0, or if there are no numbers in that cell, the 0 does not display or print. Solutions: There is no way to do this in WordPerfect 5.1.

It can be accomplished in WordPerfect 6.1 by using an IF/THEN Statement "If(calculation=0, NA(), calculation)" (Example: If(SUM(A1-A2)=0, NA(), SUM(A1-A2)).

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.