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.

# Understand spreadsheet-style formula functions

**Last updated:**

## 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`

Need More Help?

### Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.Get Help

### Hire an Expert

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

### Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.Check out the community