Organizations can use over 100 kinds of formulas in the spreadsheet template that you upload for a Table field. For information on how to create and use a spreadsheet formula, we recommend using online resources 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 signing up for Tables? Email us at sales@submittable.com.