Available on plans:
Free
Pro
Team
Enterprise
This article covers the different spreadsheet-style formula functions you can use in the Formatter step in Zaps. Learn how to use spreadsheet-style formulas in Zaps.
Formula Functions
| ABS(number) | Returns the absolute value of a number |
| ACOS(number) | Returns the inverse cosine of a number |
| ACOSH(number) | Returns the inverse hyperbolic cosine of a number |
| AND(condition, [condition, …]) | Returns TRUE if all of the conditions evaluate to TRUE, otherwise FALSE |
| ASIN(number) | Returns the inverse sine of a number |
| ASINH(number) | Returns the inverse hyperbolic sine of a number |
| ATAN(number) | Returns the inverse tangent of a number |
| ATAN2(x, y) | Returns the inverse tangent of a pair of x and y coordinates |
| ATANH(number) | Returns the inverse hyperbolic tangent of a number |
| AVERAGE(number, [number, …]) | Returns the average of a list of numbers |
| CEILING(number, [factor]) | Returns a number rounded up to the nearest multiple of factor (e.g., CEILING(3.14159, 0.1) = 3.2 and CEILING(3.14159, 2) = 4) |
| COS(number) |
Returns the cosine of a number
|
| COSH(number) | Returns the hyperbolic cosine of a number |
| DEGREES(radians) | Returns radians converted to a value in degrees |
| EVEN(number) | Rounds a number up to the next even number |
| EXP(number, power) | Returns the constant e raised to a power |
| FACT(number) | Returns the factorial of a number |
| FACTDOUBLE(number) | Returns the double factorial of a number |
| FALSE() | Returns the logical value FALSE |
| FLOOR(number, [factor]) | Returns a number rounded down to the nearest multiple of factor (e.g., FLOOR(3.14159, 0.1) = 3.1 and FLOOR(3.14159, 2) = 2) |
| GCD(number, number, [number, …]) |
Returns the greatest common divisor of two or more numbers
|
| GEOMEAN(number, [number, …]) | Returns the geometric mean of a list of numbers |
| IF(condition, true_value, [false_value]) | Returns the true_value if the condition is TRUE or false_value if the condition is FALSE |
| INT(number) | Returns a number rounded down to the previous integer |
| ISBLANK(value) | Returns TRUE if a value is blank (empty); Otherwise, returns FALSE |
| ISEVEN(value) | Returns TRUE if a value is an even number; Otherwise, returns FALSE. |
| ISLOGICAL(value) | Returns TRUE if a value is a logical value; Otherwise, returns FALSE |
| ISNONTEXT(value) | Returns TRUE if a value is NOT text; Otherwise, returns FALSE |
| ISNUMBER(value) | Returns TRUE if a value is a number; Otherwise, returns FALSE |
| ISODD(value) | Returns TRUE if a value is an odd number; Otherwise, returns FALSE |
| ISTEXT(value) | Returns TRUE if a value is text; Otherwise, returns FALSE |
| LCM(number, number, [number, …]) | Returns the least common multiple of two or more numbers |
| LN(number) | Returns the natural logarithm of a number |
| LOG(number, base) | Returns the logarithm of a number, to a specified base |
| LOG10(number) | Returns the base 10 logarithm of a number |
| MAX(number, [number, …]) | Returns the largest value from a list of numbers |
| MEDIAN(number, [number, …]) | Returns the median (the middle value) of a list of numbers |
| MIN(number, [number, …]) | Returns the smallest value from a list of numbers |
| MOD(dividend, divisor) | Returns the remainder from a division between two numbers |
| MODE(number, [number, …]) | Returns the mode (the most frequently occurring value) of a list of numbers |
| NOT(condition) | Returns a logical value that is the opposite of a condition (ie. returns FALSE if condition is TRUE and returns TRUE if condition is FALSE) |
| ODD(number) |
Returns a number rounded up to the next odd number
|
| OR(condition, [condition, …]) | Returns TRUE if any of the conditions evaluate to TRUE, otherwise FALSE |
| PI() | Returns the constant value of Pi |
| POW(number, power) | Returns the result of a number raised to a power |
| POWER(number, power) | Returns the result of a number raised to a power |
| PRODUCT(number, [number, …]) | Returns the product of a list of numbers |
| QUOTIENT(dividend, divisor) | Returns the integer portion of a division between two numbers |
| RADIANS(degrees) | Returns degrees converted to a value in radians |
| RAND() | Returns a random number between 0 and 1 |
| RANDBETWEEN(min, max) | Returns a random number between two integers |
| ROUND(number, [places]) | Returns a number rounded up or down (following standard rules) to a certain number of decimal places |
| ROUNDDOWN(number, [places]) | Returns a number rounded up to a certain number of decimal places |
| ROUNDUP(number, [places]) | Returns a number rounded up to a certain number of decimal places |
| SIGN(number) | Returns the sign (+, -, 0) of a number |
| SIN(number) | Returns the sine of a number |
| SINH(number) | Returns the hyperbolic sine of a number |
| SQRT(number) | Returns the positive square root of a number |
| SQRTPI(number) | Returns the square root of a number multiplied by the constant Pi |
| SUM(number, [number, …]) | Returns the sum of a list of numbers |
| TAN(number) | Returns the tangent of a number |
| TANH(number) | Returns the hyperbolic tangent of a number |
| TRUE() | Returns the logical value TRUE |
| TRUNC(number, [places]) | Returns a number truncated to a certain number of significant digits by omitting less significant digits |
| VALUE(text) | Returns the text converted to a numeric value |
Arithmetic operators
| Negation | -A converts A to a negative number |
| Percent | A% converts A to a percentage value by dividing it by 100 |
| Exponentiation | A ^ B raises A number to the power of B |
| Multiplication | A * B multiplies A by B |
| Division | A / B divides A by B |
| Addition | A + B adds B to A |
| Subtraction | A - B subtracts B from A |
| Concatenation | "A" & "B" concatenates the text value A and B into a single text value "AB" |
Comparison formulas
| Equal | A = B is TRUE when A is equal to B |
| Not Equal | A <> B is TRUE when A is not equal to B |
| Greater Than | A > B is TRUE when A is greater than B |
| Less Than | A < B is TRUE when A is less than B |
| Greater Than or Equal | A >= B is TRUE when A is greater than or equal to B |
| Less Than or Equal | A <= B is TRUE when A is less than or equal to B |
Examples
-
(1 + 2) / 4returns0.75 -
POW(2, 4)returns16 -
IF(ISEVEN(2), 100, 200)returns100 -
AND(ISODD(1), ISEVEN(2))returnsTRUE -
ROUNDUP(1234.567 * 106%, 2)returns1308.65 -
IF(1 < 2, IF(3 = 3, "you did it!", 20), 30)returnsyou did it! -
100 * (VALUE("123" & "." & "01") + 7)returns13001