The IF function calculates x and evaluates it. If x is TRUE (or not zero), the true value is displayed; if x is FALSE (or zero), the false value is displayed.
For example:
IF(m > n, m, n)
returns the larger value of m and n.
You can use logical and relational operators in an IF function. For example:
IF (A2 > 5 & A2 < 7, "A2 is OK", "A2 is not OK")
If the value in the cell A2 is greater than 5 and less than 7, Ability displays the true value "A2 is OK"; otherwise Ability displays the false value "A2 is not OK".
See also: