Microsoft KB Archive/50443

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

GET.NAME(“Sales”) Does Not Equal 523 in Excel PSS ID Number: Q50443 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

There is a documentation error on page 299 of the “Microsoft Excel Functions and Macros Guide” for version 2.x, on page 301 of the “Microsoft Excel for OS/2 Functions and Macros Guide” for version 2.x, and on page 111 of the “Microsoft Excel Function Reference” for version 3.0.

In the discussion on the macro command GET.NAME, the manuals state the following:

If the name Sales on a macro sheet is defined to be the number 523, then:

  GET.NAME("Sales") equals "523"

The previous formula actually returns “=523”.

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.