Top Navigational Bar

Absolute Cell Reference in Table Formulas (Enhancement) Wordperfect 6.0 Dos
DocumentID: 10590
Revision Date: 10-Mar-97 6:23:06 PM

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

Enhancement
You can copy table formulas in absolute format. This ensures that specific cell references do not change when you copy a formula.


Concept
In WordPerfect 6.0 for DOS, formulas can contain cell references which are absolute. An absolute cell reference is one that does not change.

For example, if you are copying the formula A1+B1 to the next row, the formula will change to B1+B2. If you always want the variable A1 to remain the same, regardless of the row or column the formula is in, you need to make that cell reference absolute.


How Do I Use It?
Place brackets around the cell reference to make the reference absolute. Continuing the above example, if you are going to move the formula A1+B1 to row 2, but you want the variable A1 to remain the same, change the original formula to read [A1]+B1. When you copy the formula to row 2, the formula will become [A1]+B2. Regardless of where you copy the formula, the variable A1will remain constant.


See Also
      Tables: Spreadsheet and Floating Cell in the WordPerfect 6.0 for DOS reference manual


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.