Oct 21 2020 06:19 AM
See the attached file Question about the if function.xlsx
I do not understand that =if(25-23;True;False) result is
Oct 21 2020 07:28 AM
Oct 21 2020 07:28 AM
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.
Oct 21 2020 07:43 AM
Oct 21 2020 07:43 AM
Oct 21 2020 10:03 AM