Help

Understand spreadsheet-style formula functions

reference
Last updated:

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 doc helpful?

Need More Help?

Zapier Support

Contact our world class support team and we’ll be happy to help you get up and running!
Contact Us

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert