Microsoft KB Archive/75821

{| = Excel: IF Function Returns 0 Instead of TRUE or FALSE =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q75821

SUMMARY
Page 125 of the &quot;Microsoft Excel Function Reference&quot; version 3.0 manual incorrectly states that &quot;If logical_test is TRUE and value_if_true is omitted, TRUE is returned&quot; and &quot;If logical_test is FALSE and value_if_false is omitted, FALSE is returned.&quot;

If value_if_true is not included in the formula &quot;=IF(logical_test,,value_if_false)&quot;, then 0 (zero) will be returned if logical_test is TRUE. If value_if_false is not included in the formula &quot;=IF(logical_test,value_if_true,)&quot;, then a 0 will be returned if logical_test is FALSE. However, if value_if_false is left off in the formula &quot;=IF(logical test,value_if_true)&quot;, then FALSE will be returned when logical_test is FALSE.

MORE INFORMATION
To get the IF function to return either TRUE or FALSE depending on the value of logical_test, value_if_true and value_if_false should have TRUE and FALSE entered for their respective arguments. For example, the following formula

=IF(logical_test,TRUE,FALSE) will return TRUE if logical_test is TRUE and FALSE if logical_test is FALSE.
 * }