Excel: IS Functions with External References Appear Incorrect

Last reviewed: November 3, 1994
Article ID: Q78783

Summary:

Certain IS functions (ISNUMBER, ISBLANK, ISTEXT, ISLOGICAL, and ISNONTEXT) that contain references to external worksheets may appear to evaluate incorrectly if Microsoft Excel for the Macintosh version 3.0 opens a document created in Excel version 2.2. If you reenter the formulas by activating the Formula Bar and pressing RETURN, the functions calculate correctly.

More Information:

If a worksheet contains many IS functions, it may not be practical to enter the formulas again. To enter all formulas at once and ensure that functions containing external references are evaluated correctly, use the following procedure:

From the Formula menu, choose Replace.
Type an equal sign in the Find What field.
Type an equal sign in the Replace With field.
Choose Replace All.

This procedure only needs to be done once for each document. If you save the document in Normal format and open it again, the functions continue to evaluate correctly.

Microsoft is researching this problem and will post new information here as it becomes available.

KBCategory: kbother
KBSubcategory:
Additional reference words: 3.00 logical

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.