The Boolean Airkit type has two values TRUE and FALSE. It used to answer
"Yes or No" style of questions. For example a Checkbox component uses a Boolean
value to determine whether or not it should be displayed with a check or not.
Booleans are also useful for the conditional IF function. For example the
function ISNUMBER will return TRUE if the argument is a Number type, and
FALSE otherwise. One can use this function combined with IF to
conditionally perform some operation depending on if a value is a Number like
so:
IF(ISNUMBER(my_variable), FORMAT_NUMBER(my_variable, "#"), "Not a number")
Add comment
Article is closed for comments.