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 false.
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 Excel.
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 string.
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.
Article is closed for comments.