Available on plans:
Free
Starter
Professional
Team
Company
This article covers the different spreadsheetstyle formula functions you can use in the Formatter step in Zaps. Learn how to use spreadsheetstyle 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
Formula Arithmetic
 Negation Operator: A converts A to a negative number
 Percent Operator: A% converts A to a percentage value by dividing it by 100
 Exponentiation Operator: A ^ B raises A number to the power of B
 Multiplication Operator: A * B multiplies A by B
 Division Operator: A / B divides A by B
 Addition Operator: A + B adds B to A
 Subtraction Operator: A  B subtracts B from A
 Concatenation Operator: "A" & "B" concatenates the text value A and B into a single text value "AB"
Formula Comparisons
 Equal Condition: A = B is TRUE when A is equal to B
 Not Equal Condition: A <> B is TRUE when A is not equal to B
 Greater Than Condition: A > B is TRUE when A is greater than B
 Less Than Condition: A < B is TRUE when A is less than B
 Greater Than or Equal Condition: A >= B is TRUE when A is greater than or equal to B
 Less Than or Equal Condition: A <= B is TRUE when A is less than or equal to B
Formula Examples

(1 + 2) / 4
returns0.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