Microsoft KB Archive/29492

-

{| 1.x 2.20 3.00 4.00 | 2.x 3.00 4.00 | 2.20 2.21 3.00 MACINTOSH         | WINDOWS       | OS/2 kbusage The information in this article applies to:
 * width="100%"|


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

SUMMARY
To test if a cell in Microsoft Excel versions 1.50 or later is blank (empty), use the statement

=IF(ISBLANK(ref),Value-if-True,Value-if-False) where &quot;ref&quot; is the cell to be tested. If ref is empty, Value-if-True is returned. If ref contains something, Value-if-False is returned. If you are using Microsoft Excel version 1.06 or earlier, use the following formula:

=IF(ref=&quot;&quot;,Value-if-True,Value-if-False)
 * }

-

Last reviewed: December 2, 1994

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.