XL97: Page Fault Using Formula Containing Boolean Functions

Last reviewed: February 12, 1998
Article ID: Q167188

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

When you enter a formula into your worksheet, one of the following error messages appears:

   Microsoft Windows 95
   --------------------
   
      This program has performed an illegal operation
      and will be shut down.
   
      If the problem persists, contact the program vendor.
   
   When you click Details, the following message appears:
   
      EXCEL caused an invalid page fault in module EXCEL.EXE
      at <memory address>
   
   When you click Close, the program closes.
   
   Microsoft Windows NT
   --------------------
   
      An application error has occurred and an application error
      log is being generated.
   
   When you click OK or Cancel, the program closes.

CAUSE

This problem occurs when you enter a formula that uses a Boolean function as a comparison operator and contains parenthesis and a Boolean function. This syntax is incorrect.

RESOLUTION

To resolve this problem, enter Boolean functions as functions not as comparison operators.

Examples

The following formulas generate the Page Fault error message described in this article and cause Microsoft Excel to close:

   A1: =(B1=1) OR (B1=0)
   A2: =A2="test" IF (B1=0)
   A3: =(B3=1) AND (B3=2)
   A4: =(B4=1) NOT (B4=0)

To resolve the problem, correct the formulas as in the following table.

   Incorrect                      Correct
   ---------------------------------------------------

   A1: =(B1=1) OR (B1=0)          A1: =OR(B1=1, B1-0)
   A2: =A2="test" IF (B1=0)       A2: =IF(B1=0, "Test")
   A3: =(B3=1) AND (B3=2)         A3: =OR(B3=1, B3=2)
   A4: =(B4=1) NOT (B4=0)         A4: =AND(B4=1, NOT(B4=0))

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The following is a list of Boolean functions:

   AND
   FALSE
   IF
   NOT
   OR
   TRUE

You can use logical functions to see whether a condition is true or false or to check for multiple conditions. For example, you can use the IF function to determine whether a cell is equal to a particular value. One value is returned if the condition is true, and a different value is returned if the condition is false.

REFERENCES

For more information about using logical functions in formulas, click the Index tab in Microsoft Excel 97 Help, type the following text

   boolean functions

and then double-click the selected text to go to the "About logical functions" topic.

Additional query words: XL97
Keywords : xlformula kberrmsg
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb
Solution Type : kbworkaround

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: February 12, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.