Microsoft KB Archive/50647

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 19:24, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q50647 to Microsoft KB Archive/50647 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.