Microsoft KB Archive/50647

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Works: Copying a Formula Containing a Named Reference

PSS ID Number: Q50647 Article last modified on 10-16-1998

2.00 3.00


====================================================================== 2.00 3.00 MS-DOS kbother

The information in this article applies to:
- Microsoft Works for MS-DOS, versions 2.0 and 3.0


In versions 2.0 and 3.0 of Microsoft Works for MS-DOS, when you copy a formula with a cell name in it and paste it into another cell, the reference acts as a relative reference.


To force a formula that refers to a named cell NOT change with movement, you must make it an absolute reference.


  1. Begin with a value in cell A1, and name that cell “Interest.”

  2. Put the formula “=Interest+10” in cell B1.

  3. Copy the formula from cell B1 to B2. The formula in B2 now incorrectly reads =A2+10. To avoid this problem, you must precede the original formula with a dollar sign ($). This makes the formula absolute.

    The above formula in step 2 should appear as follows:


KBCategory: kbother KBSubcategory: dworkskb

Additional reference words: 2.00 3.00

====================================================================== Version : 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.