IF

cond: condition

trueval: value to use if condition is true

falseval: value to use if condition is false

This function first evaluates the condition. If the result is true, it will then evaluate and return the second argument. Otherwise, it will evaluate and return the last argument.

AND, OR, XOR, NOT, IFERROR.