Microsoft KB Archive/25486

-

{| 1.x 2.20 3.00 4.00 MACINTOSH kbusage
 * width="100%"|

SUMMARY
When the "value_if_false" argument is omitted from the IF command and the "logical_test" argument returns FALSE, the word "FALSE" is displayed in the cell containing the formula.

To display a blank cell when the "logical_test" argument returns FALSE, enter two quotation marks (without a space between them) in place of the optional "value_if_false" argument, as shown below:

=IF(logical_test,value_if_true,"") For more information on the IF command, see pages 227-228 in the "Microsoft Excel Function Reference," version 4.0. If you are using version 3.0, see pages 125-126 (form 1) in the "Microsoft Excel Function Reference" version 3.0. If you are using Excel 2.20, see pages 43-44 in the "Microsoft Excel Functions and Macros" version 2.2.
 * }

-

Last reviewed: December 1, 1994

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