1. Zapier
  2. Zaps
  3. Built-in tools
  4. Formatter

Understand spreadsheet-style formula functions

Updated

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

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 returns 0.75
  • POW(2, 4) returns 16
  • IF(ISEVEN(2), 100, 200) returns 100
  • AND(ISODD(1), ISEVEN(2)) returns TRUE
  • ROUNDUP(1234.567 * 106%, 2) returns 1308.65
  • IF(1 < 2, IF(3 = 3, "you did it!", 20), 30) returns you did it!
  • 100 * (VALUE("123" & "." & "01") + 7) returns 13001
Was this article helpful?
17 out of 25 found this helpful

Zapier Early Access

Get access to tomorrow’s no-code automation products and features today. By opting-in to our current and future pre-release products, you’ll work directly with the Zapier product team and join a dedicated community of automation enthusiasts. Learn more about Zapier Early Access