Excel: Returning a Blank Cell When IF Command Returns FALSELast reviewed: December 1, 1994 |
1.x 2.20 3.00 4.00 MACINTOSH kbusage SUMMARYWhen 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. |
KBCategory: kbusage |
Last reviewed: December 1, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.