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

The information in this article applies to: |

- Microsoft Works for MS-DOS, versions 2.0 and 3.0 |

# 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.