Data Types

Formulas work with three types of data: numbers, strings, and arrays.

Numbers are floating point. Numbers also include the value NaN (for "not a number") which represents error results (for example attempting to convert the string "WILL_NOT_PARSE" into a number). The result of applying an operator to the NaN value is also NaN. For example, NaN + 4 = NaN and NaN / 3 = NaN.

String constants are delimited by double quote characters. The backslash is used as an escape character: \" generates a double quote inside the string, \\ generates a single backslash inside the string, and \n generates a newline inside the string.

A number can be converted to a string and vice versa using the functions number() and string().