Functions and operators available in Zapier Tables

Written by Owner

Updated at August 20th, 2025

+ More

Table of Contents

Functions Logical functions Arithmetical functions Date and time functions Operators Arithmetic operators Comparison operators

Available on plans:

Free

Pro

Advanced

This is a list of all the functions and operators available for Formula fields in Zapier Tables and how to use them. You can enter any value in a function, or select existing fields from the Insert Fields tab below the Formula text field. Learn how to create a Formula field.

Note

Formulas must be valid to be used in a field. Learn how to troubleshoot formulas.

Functions

Each function within a formula requires arguments (pieces of information) to complete the calculation, and the number of arguments required depends on the function you use.

Arguments can be a field from your table, a numerical value, or a string (text) that you type directly into the formula. When using a string, you must surround it with double quotation marks, e.g. to check if a field contains the country France, use "France" in your formula.

Logical functions

Function	Description	Usage
IF()	Checks if a logical expression is evaluated as 'true' or 'false', and returns the first or second value, depending on the result.	IF(logical_expression, value_if_true, value_if_false) Example: IF(ORDERQUANTITY > 20, "Large order","Small order")
NOT()	Returns 'true' if the value is the opposite of the expression, and 'false' if it's the same as the expression. Only accepts one argument.	NOT(logical_expression) Example: NOT(ORDERTOTAL = "100")
ALL()	Checks all values in the expression and returns 'true' when all values are evaluated as 'false'. Accepts multiple arguments.	ALL(logical_expression_1, logical_expression_2,...) Example: ALL(ORDERTOTAL > "100", ORDERQUANTITY > "20", COUNTRY = “USA”)
ANY()	Checks all values in the expression and returns 'true' if any is 'true'. Accepts multiple arguments.	ANY(logical_expression_1, logical_expression_2,...) Example: ANY(ORDERTOTAL < "50", ORDERQUANTITY < "10")
ISTEXT()	Checks if the value is a string. Only accepts one argument.	ISTEXT(value)
ISNUMBER()	Checks if the value is a number. Only accepts one argument.	ISNUMBER(value)
ISBOOL()	Checks if the value is a boolean (true or false). Only accepts one argument.	ISBOOL(value)
ISNULL()	Checks if the value is NULL and returns 'true' if so. Only accepts one argument.	ISNULL(value)
LT()	Checks if the first value is smaller than the second. Requires two arguments.	LT(value_1, value_2) Example: LT(30,40)
GT()	Checks if the first value is larger than the second. Requires two arguments.	GT(value_1, value_2) Example: GT(50,40)
LE()	Checks if the first value is less than or equal to the second. Requires two arguments.	LE(value_1, value_2) Example: LE(20,40)
GE()	Checks if the first value is greater than or equal to the second. Requires two arguments.	GE(value_1, value_2) Example: GE(30,10)
EQ()	Checks if two values are equal. Requires two arguments.	EQ(value_1, value_2) Example: EQ(ORDERTOTAL,180)
NE()	Checks if two values are not equal. Requires two arguments.	NE(value_1, value_2) Example: NE(COUNTRY,”SPAIN”)
CONTAINS()	Checks if the first value contains the second value and returns 'true' if so. Case-sensitive. Requires two arguments.	CONTAINS(value_1, value_2) Example: CONTAINS("Motorcycles", "Moto")
ICONTAINS()	Checks if the first value contains the second value and returns 'true' if so. Not case-sensitive. Requires two arguments.	CONTAINS(value_1, value_2) Example: ICONTAINS("Motorcycles", "moto")

Arithmetical functions

Function	Description	Usage
SUM()	Adds up all numbers given and returns the total sum. Accepts multiple arguments.	SUM(value_1, value_2,...) Example: SUM(10,50,40)
AVERAGE()	Calculates the arithmetic mean of the given numbers. Accepts multiple arguments.	AVERAGE(value_1, value_2,...) Example: AVERAGE(10,240,31,22)
CONCAT()	Joins two values as a single text string. Requires two arguments.	CONCAT(string_1, string_2) Example: CONCAT(ADDRESS,COUNTRY)
SUB()	Subtracts the second number from the first and returns the result. Requires two arguments.	SUB(value_1, value_2) Example: SUB(20,15)
DIV()	Divides the first number by the second and returns the result. Returns an error if dividing by zero. Requires two arguments.	DIV(value_1, value_2) Example: DIV(50,40)
MUL()	Multiplies all given numerical values and returns the result. Requires two arguments.	MUL(value_1, value_2) Example: MUL(30,20)
SUMIF	Sums the values in a range when a condition is met. Accepts multiple arguments.	SUMIF(condition, field_1, field_2, field_3, ...) Example: SUMIF(EQ(field_1, 100), order_value, shipping_value, tax)
ROUND	Rounds the provided value to a specified precision, in decimal places. If no precision is set, rounds to the nearest whole number.	ROUND(value, [precision]) Examples: ROUND(234.23634) = 234 ROUND(234.23634, 2) = 234.24
ROUNDUP	Rounds the provided value up to a specified precision, in decimal places. If no precision is set, rounds to the nearest whole number.	ROUNDUP(value, [precision]) Examples: ROUNDUP(4.123) = 5 ROUNDUP(4.1233, 3) = 4.124
ROUNDDOWN	Rounds the provided value down to a specified precision, in decimal places. If no precision is set, rounds to the nearest whole number.	ROUNDDOWN(value, [precision]) Examples: ROUNDDOWN(4.123) = 4 ROUNDDOWN(4.123, 1) = 4.1
CEILING	Divides the first number by the second and rounds up to the nearest whole number. Requires two arguments.	CEILING(value_1,value_2) Example: CEILING(23,2) = 12
FLOOR	Divides the first number by the second and rounds down to the nearest whole number. Requires two arguments.	FLOOR(value_1,value_2) Example: FLOOR(23,2) = 11
ABS	Returns the absolute value of a number. Optionally, add "true" as a second argument to display an error message when the value is not a number.	ABS(value,[error]) Example: ABS(-234.23634) = 234.23634 ABS("banana") = field appears blank ABS(“banana", true) = displays error on field
COUNT	Counts the number of inputs passed to the function. Accepts multiple arguments.	COUNT(value_1, value_2, …) Example: COUNT(2, 3, 10, 2) = 4
RAND	Returns a random number between 0 and 1. Does not require arguments.	RAND()
RANDBETWEEN	Returns a random integer between a lower and upper range. Requires two arguments.	RANDBETWEEN(1, 10) = 1 Example: RANDBETWEEN(1, 10)
POWER	Raises the first value to the exponent passed as the second value. Requires two arguments.	POWER(value_1, value_2) Example: POWER(2, 3) = 8

Date and time functions

Function	Description	Usage
TODATETIME()	Converts a value into ISO8601 date and time format. Optionally, add “true” as a second argument to display `n/a` instead of an error when the date and time cannot be converted.	TODATETIME(value_1, [error]) Example: TODATETIME(ORDERDATE, false)
UTCNOW	Returns the current time's ISO 8601 UTC timestamp. Optionally, pass an hour offset to indicate the timezone for the timestamp.	UTCNOW([time_offset]) Example: UTCNOW() UTCNOW(-5)
ONUPDATE	Re-checks the result of the first value if any of the provided fields is updated. Accepts multiple arguments.	ONUPDATE(function, field_1, field_2,...) Example: ONUPDATE(EQ(DEPT_NAME,"HR"), TICKET_STATUS, RESOLUTION)
DATEDIFF	Compares two timestamps and calculates the time difference between them in the unit defined. Accepts the following units: Minute Hour Day Month Year	DATEDIFF(value_1, value_2, unit) Example: DATEDIFF("2025-02-07T15:45:38.821560+00:00", "2025-02-08T15:45:38.821560+00:00", "day")

Operators

Arithmetic operators

Operator	Description	Usage
+	Adds a field or value to another.	value_1 + value_2
-	Subtracts a field or value from another.	value_1 - value_2
*	Multiplies a field or value by another.	value_1 * value_2
/	Divides a field or value by another.	value_1 / value_2

Comparison operators

Operator	Description	Usage
=	Compares if a field or value matches another.	value_1 = value_2
<	Checks if a field or value is lower than another.	value_1 < value_2
>	Checks if a field or value is greater than another.	value_1 > value_2
<=	Checks if a field or value is lower than or equal to another.	value_1 <= value_2
>=	Checks if a field or value is greater than or equal to another.	value_1 >= value_2
!=	Checks if a field or value is different from another.	value_1 != value_2