The if function is incomplete but still give True as result

New Contributor

See the attached file Question about the if function.xlsx


I do not understand that =if(25-23;True;False) result is

5 Replies


Excel regards 0 as FALSE and any other number as TRUE.



The syntax of IF is IF(condition; value_if_true; value_if_false)

The function will return value_if_true if condition evaluates to TRUE, but also if it evaluates to a non-zero number.

If will return value_if_false if condition evaluates to FALSE, but also if it evaluates to 0.


In your example, condition evaluates to 25-23 = 2. Since this is non-zero, value_if_true is returned. This is used to return the last name if D11 contains a space, and the value of D11 itself if it doesn't contain a space.

Thanks for your quick response.
Thanks for your quick response.


Other words, the equivalent of your IF() is