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

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

= SUMMARY =

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.

= MORE INFORMATION =

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

Example
  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: =$Interest+10 

KBCategory: kbother KBSubcategory: dworkskb

Additional reference words: 2.00 3.00

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