Microsoft Knowledge Base

XL: Problems with Function Wizard and IS Functions
Last reviewed: September 13, 1996
Article ID: Q118849
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0

SYMPTOMS

In Microsoft Excel, when you use the Function Wizard with an IS function, and you refer to a cell reference, the Function Wizard converts the cell reference to a text string by inserting quotation marks around the reference.

For example, if you attempt to refer to cell A1, the Function Wizard will return the following formula: 

   =ISERROR("A2")
This behavior will cause the formula to return incorrect results.

CAUSE

This problem occurs with the following IS functions: 

   ISBLANK()
   ISERR()
   ISERROR()
   ISEVEN()
   ISLOGICAL()
   ISNA()
   ISNONTEXT()
   ISNUMBER()
   ISODD()
   ISREF()
   ISTEXT()
when the cell being referred to contains an error value, such as #N/A. If the cell is blank or contains an alphanumeric value, the functions will work correctly.

WORKAROUND

To work around this problem, enter the formula manually rather than with the Function Wizard.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel version 5.0 for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

KBCategory: kbprb
KBSubcategory:

Additional reference words: 7.00 5.00



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: September 13, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.