Converts argument to a number. If the argument doesn't parse as a number, returns NaN.
Converts argument to a string.
Takes any number of arguments. Return first argument that is not NaN. Useful for providing default
values when there are unexpected values in the inputs to the formula.
Logical not of one scalar argument
Logical or of two scalar arguments
Logical and of two scalar arguments
Logical xor of two arguments
Takes three arguments. Tests first argument, returning second argument if true and third argument if
First argument is value to be tested. It is compared to the even arguments (second argument, fourth
argument, etc.). Returns the argument following the first match. If there is no match and it was called
with an even number of arguments, returns the last argument. If there is no match and it was called
with an odd number of arguments, returns NaN.
Takes two arguments. First argument is array. Compares second argument against each element of
array. If second argument equals any element of array, then returns true.
Compute minimum value of any number of arguments
Compute maximum value of any number of arguments
Round first argument towards plus infinity
Round first argument towards minus infinity
Round the first argument towards nearest integer. Optionally take second argument specifying number
of decimal places.
Removes all zero, NaN, or empty strings from an array.
Concatenates an array of string into a single string. Similar to join method of array object in
Takes any number of arguments and joins them into a string. Similar to the CONCATENATE function in
Create a new array as a sub-section of an existing array. Similar to slice method of array object in
and third argument is replacement string. Searches source string for all matches to regular expression
and replaces each match with the replacement string.
Substitutes HTML special characters with the equivalent entity. Replace ampersand, double quote,
single quote, less than, and greater than characters.
Wraps first argument in double quotes after escaping all double quotes and backslashes within the
First argument is a name and second argument an email address. Returns address properly quoted for
including in an email header, handling case where name or email address is missing.