Microsoft KB Archive/22092

Reference Keys and Building Formulas with Absolute References PSS ID Number: Q22092 Article last modified on 04-14-1987 PSS database name: D_MPlan

2.00 2.01 3.00

MS-DOS

Question: How do I use the reference key in building a formula with absolute references?

Response: If you are building a formula and want to turn a relative reference into an absolute reference, you can use the reference key. For example, suppose you are building a formula that currently looks like “SUM(R[-14]C” and you decide you want to use absolute references instead of relative references. At this point in the formula you would press your F3 or @ key to do the reference conversion, and then continue building the rest of the formula. These and other keys are defined in the Multiplan documentation and through the Help command in the program.

Copyright Microsoft Corporation 1987.