IF(condition, value1, value2)
If condition is true, value1 is returned. Otherwise, value2 is returned.
AND and OR operators are supported in the condition.
IF(IS_PRESENT(x) AND IS_PRESENT(y), "Both present!", "One or both missing!")
IF(IS_PRESENT(x) OR IS_PRESENT(y), "One or both present!", "Both missing!")
IS_BLANK(value)
Checks whether the variable value is empty.
MATH.IS_EVEN(value)
Checks whether the number value is even.
TIME.IS_LEAPYEAR(value)
Checks whether the datetime value is a leap year.
MATH.IS_ODD(value)
Checks whether the number value is odd.
IS_PRESENT(value)
Checks whether the variable value exists.
NOT(value)
Returns the opposite of the boolean value.