Microsoft KB Archive/23605

{|
 * width="100%"|

Excel: Getting Unexpected Results with Computed Criteria

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
 * Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0
 * Microsoft Excel for OS/2, versions 2.2, 3.0

-

SUMMARY
In a Microsoft Excel database, computed criteria return incorrect results if a field name is entered above the formula in the criteria range.

When using computed criteria, do not use a field name in the cell above the computed formula in the criteria range. Other text, usually a short description of the formula, should be entered in this cell instead.

Additional query words: 2.1 2.10 2.10c 2.2 2.20 2.21 3.0

Keywords :

Version : MACINTOSH:1.x,2.x,3.0,4.0; WINDOWS:2.x,3.0,4.0; :2.2,3.0

Platform : MACINTOSH WINDOWS

Issue type :

Technology :