Microsoft KB Archive/50647
Works: Copying a Formula Containing a Named Reference
PSS ID Number: Q50647 Article last modified on 10-16-1998
====================================================================== 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.
Begin with a value in cell A1, and name that cell “Interest.”
Put the formula “=Interest+10” in cell B1.
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.