All Collections
Build Your Program
What spreadsheet formulas can I use in Tables?
What spreadsheet formulas can I use in Tables?

When adding a table to your form, here are the Excel formulas that can be used.

Pam English avatar
Written by Pam English
Updated over a week ago

Organizations can use more than 100 formulas in an uploadable spreadsheet for a Table Field. For information on how to create and use spreadsheet formulas, we recommend using an online resource such as Microsoft Excel's formulas overview.
โ€‹
The following Excel formulas are supported in Tables:

ABS
ACOS
ACOSH
ADDRESS
AND
ASIN
ASINH
ATAN
ATAN2
ATANH

AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
CEILING
CHAR
CHOOSE
COLUMN
COLUMNS
CONCATENATE
COS
COSH
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
DATE
DATEVALUE
DAVERAGE
DAY
DAYS360
DCOUNT
DCOUNTA
DEGREES
DGET
DMAX
DMIN
DSUM
DVAR
DVARP
EDATE
EOMONTH
ERROR.TYPE
EXACT
EXP
FACT
FALSE
FIND
FIXED
FLOOR
HLOOKUP
HOUR
HYPERLINK
IF
IFERROR
IFNA
INDEX
INDIRECT
INT
ISBLANK
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISOWEEKNUM
ISTEXT
LARGE
LEFT
LEN
LN
LOG

LOG10
LOOKUP
LOWER
MATCH
MAX
MAXA
MEDIAN
MID
MIN
MINA
MINUTE
MOD
MONTH
N
NA
NOT
NOW
OFFSET
OR
PI
POWER
PRODUCT
PROPER
QUOTIENT
RAND
RANDBETWEEN
RANK
RANK.AVG
RANK.EQ
REPLACE
REPT
RIGHT
ROUND
ROUNDDOWN
ROUNDUP
ROW
ROWS
SEARCH
SECOND
SIGN
SIN
SINH
SMALL
SQRT
SQRTPI
STDEV
STDEV.P
STDEV.S
STDEVP
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
T
TAN
TANH
TEXT
TIME
TIMEVALUE
TODAY
TRUE
TRUNC
UPPER
VALUE
VAR
VARP
VLOOKUP
WEEKDAY
WEEKNUM
WORKDAY
YEAR
YEARFRAC

Questions or interested in adding Tables to your account? Email us at sales@submittable.com.


Did this answer your question?