Function reference

456 functions with the same names and arguments as Microsoft Excel, plus the monday.com functions.

FunctionCategoryArguments
ABS Math and Trig 1 Help
ACCRINT Financial 4-8 Help
ACCRINTM Financial 3-5 Help
ACOS Math and Trig 1 Help
ACOSH Math and Trig 1 Help
ACOT Math and Trig 1 Help
ACOTH Math and Trig 1 Help
ADDRESS Lookup and Reference 2-5 Help
AMORDEGRC Financial 6,7 Help
AMORLINC Financial 6,7 Help
AND Logical 1+ Help
ARABIC Math and Trig 1 Help
ARRAYTOTEXT Text and Data 1,2 Help
ASIN Math and Trig 1 Help
ASINH Math and Trig 1 Help
ATAN Math and Trig 1 Help
ATAN2 Math and Trig 2 Help
ATANH Math and Trig 1 Help
AVEDEV Statistical 1+ Help
AVERAGE Statistical 1+ Help
AVERAGEA Statistical 1+ Help
AVERAGEIF Statistical 2,3 Help
AVERAGEIFS Statistical 3+ Help
BAHTTEXT Text and Data 1 Help
BASE Math and Trig 2,3 Help
BESSELI Engineering 2 Help
BESSELJ Engineering 2 Help
BESSELK Engineering 2 Help
BESSELY Engineering 2 Help
BETA.INV Statistical 3-5 Help
BETADIST Statistical 3-5 Help
BETAINV Statistical 3-5 Help
BIN2DEC Engineering 1 Help
BIN2HEX Engineering 1,2 Help
BIN2OCT Engineering 1,2 Help
BINOM.DIST Statistical 4 Help
BINOM.DIST.RANGE Statistical 3,4 Help
BINOM.INV Statistical 3 Help
BINOMDIST Statistical 4 Help
BITAND Engineering 2 Help
BITLSHIFT Engineering 2 Help
BITOR Engineering 2 Help
BITRSHIFT Engineering 2 Help
BITXOR Engineering 2 Help
CEILING Math and Trig 1-2 Help
CEILING.MATH Math and Trig 1-3 Help
CEILING.ODS Math and Trig 1-3 Help
CEILING.PRECISE Math and Trig 1,2 Help
CEILING.XCL Math and Trig 2 Help
CHAR Text and Data 1 Help
CHIDIST Statistical 2 Help
CHIINV Statistical 2 Help
CHISQ.DIST Statistical 3 Help
CHISQ.DIST.RT Statistical 2 Help
CHISQ.INV Statistical 2 Help
CHISQ.INV.RT Statistical 2 Help
CHISQ.TEST Statistical 2 Help
CHITEST Statistical 2 Help
CHOOSE Lookup and Reference 2+ Help
CHOOSECOLS Lookup and Reference 2+ Help
CHOOSEROWS Lookup and Reference 2+ Help
CLEAN Text and Data 1 Help
CODE Text and Data 1 Help
COLUMN Lookup and Reference -1 Help
COLUMNS Lookup and Reference 1 Help
COMBIN Math and Trig 2 Help
COMBINA Math and Trig 2 Help
COMPLEX Engineering 2,3 Help
CONCAT Text and Data 1+ Help
CONCATENATE Text and Data 1+ Help
CONFIDENCE Statistical 3 Help
CONFIDENCE.NORM Statistical 3 Help
CONVERT Engineering 3 Help
CORREL Statistical 2 Help
COS Math and Trig 1 Help
COSH Math and Trig 1 Help
COT Math and Trig 1 Help
COTH Math and Trig 1 Help
COUNT Statistical 1+ Help
COUNTA Statistical 1+ Help
COUNTBLANK Statistical 1 Help
COUNTIF Statistical 2 Help
COUNTIFS Statistical 2+ Help
COUPDAYBS Financial 3,4 Help
COUPDAYS Financial 3,4 Help
COUPDAYSNC Financial 3,4 Help
COUPNCD Financial 3,4 Help
COUPNUM Financial 3,4 Help
COUPPCD Financial 3,4 Help
COVAR Statistical 2 Help
COVARIANCE.P Statistical 2 Help
CRITBINOM Statistical 3 Help
CSC Math and Trig 1 Help
CSCH Math and Trig 1 Help
CUMIPMT Financial 6 Help
CUMPRINC Financial 6 Help
DATE Date and Time 3 Help
DATEDIF Date and Time 2,3 Help
DATEVALUE Date and Time 1 Help
DAVERAGE Database 3 Help
DAY Date and Time 1 Help
DAYS Date and Time 2 Help
DAYS360 Date and Time 2,3 Help
DB Financial 4,5 Help
DCOUNT Database 3 Help
DCOUNTA Database 3 Help
DDB Financial 4,5 Help
DEC2BIN Engineering 1,2 Help
DEC2HEX Engineering 1,2 Help
DEC2OCT Engineering 1,2 Help
DEGREES Math and Trig 1 Help
DELTA Engineering 1,2 Help
DEVSQ Statistical 1+ Help
DGET Database 3 Help
DISC Financial 4,5 Help
DMAX Database 3 Help
DMIN Database 3 Help
DOLLAR Text and Data 1,2 Help
DOLLARDE Financial 2 Help
DOLLARFR Financial 2 Help
DPRODUCT Database 3 Help
DROP Lookup and Reference 2-3 Help
DSTDEV Database 3 Help
DSTDEVP Database 3 Help
DSUM Database 3 Help
DVAR Database 3 Help
DVARP Database 3 Help
EDATE Date and Time 2 Help
EFFECT Financial 2 Help
ENCODEURL Web 1 Help
EOMONTH Date and Time 2 Help
ERF Engineering 1,2 Help
ERF.PRECISE Engineering 1 Help
ERFC Engineering 1 Help
ERFC.PRECISE Engineering 1 Help
ERROR.TYPE Information 1 Help
EVEN Math and Trig 1 Help
EXACT Text and Data 2 Help
EXP Math and Trig 1 Help
EXPAND Lookup and Reference 2-4 Help
EXPON.DIST Statistical 3 Help
EXPONDIST Statistical 3 Help
F.DIST Statistical 4 Help
FACT Math and Trig 1 Help
FACTDOUBLE Math and Trig 1 Help
FALSE Logical 0 Help
FILTER Lookup and Reference 2-3 Help
FIND Text and Data 2,3 Help
FINDB Text and Data 2,3 Help
FISHER Statistical 1 Help
FISHERINV Statistical 1 Help
FIXED Text and Data 1-3 Help
FLOOR Math and Trig 1-2 Help
FLOOR.MATH Math and Trig 1-3 Help
FLOOR.ODS Math and Trig 1-3 Help
FLOOR.PRECISE Math and Trig 1-2 Help
FLOOR.XCL Math and Trig 2 Help
FORECAST Statistical 3 Help
FORECAST.LINEAR Statistical 3 Help
FORMULATEXT Lookup and Reference 1 Help
FV Financial 3-5 Help
FVSCHEDULE Financial 2 Help
GAMMA Statistical 1 Help
GAMMA.DIST Statistical 4 Help
GAMMA.INV Statistical 3 Help
GAMMADIST Statistical 4 Help
GAMMAINV Statistical 3 Help
GAMMALN Statistical 1 Help
GAMMALN.PRECISE Statistical 1 Help
GAUSS Statistical 1 Help
GCD Math and Trig 1+ Help
GEOMEAN Statistical 1+ Help
GESTEP Engineering 1,2 Help
GROWTH Statistical 1-4 Help
HARMEAN Statistical 1+ Help
HEX2BIN Engineering 1,2 Help
HEX2DEC Engineering 1 Help
HEX2OCT Engineering 1,2 Help
HLOOKUP Lookup and Reference 3,4 Help
HOUR Date and Time 1 Help
HSTACK Lookup and Reference 1+ Help
HYPERLINK Lookup and Reference 1,2 Help
HYPGEOMDIST Statistical 4 Help
IF Logical 2-3 Help
IFERROR Logical 2 Help
IFNA Logical 2 Help
IFS Logical 2+ Help
IMABS Engineering 1 Help
IMAGINARY Engineering 1 Help
IMARGUMENT Engineering 1 Help
IMCONJUGATE Engineering 1 Help
IMCOS Engineering 1 Help
IMCOSH Engineering 1 Help
IMCOT Engineering 1 Help
IMCSC Engineering 1 Help
IMCSCH Engineering 1 Help
IMDIV Engineering 2 Help
IMEXP Engineering 1 Help
IMLN Engineering 1 Help
IMLOG10 Engineering 1 Help
IMLOG2 Engineering 1 Help
IMPOWER Engineering 2 Help
IMPRODUCT Engineering 1+ Help
IMREAL Engineering 1 Help
IMSEC Engineering 1 Help
IMSECH Engineering 1 Help
IMSIN Engineering 1 Help
IMSINH Engineering 1 Help
IMSQRT Engineering 1 Help
IMSUB Engineering 2 Help
IMSUM Engineering 1+ Help
IMTAN Engineering 1 Help
INDEX Lookup and Reference 2-4 Help
INDIRECT Lookup and Reference 1,2 Help
INFO Information 1 Help
INT Math and Trig 1 Help
INTERCEPT Statistical 2 Help
INTRATE Financial 4,5 Help
IPMT Financial 4-6 Help
IRR Financial 1,2 Help
ISBLANK Information 1 Help
ISERR Information 1 Help
ISERROR Information 1 Help
ISEVEN Information 1 Help
ISFORMULA Information 1 Help
ISLOGICAL Information 1 Help
ISNA Information 1 Help
ISNONTEXT Information 1 Help
ISNUMBER Information 1 Help
ISODD Information 1 Help
ISOWEEKNUM Date and Time 1 Help
ISPMT Financial 4 Help
ISREF Information 1 Help
ISTEXT Information 1 Help
KURT Statistical 1+ Help
LARGE Statistical 2 Help
LCM Math and Trig 1+ Help
LEFT Text and Data 1,2 Help
LEFTB Text and Data 1,2 Help
LEN Text and Data 1 Help
LENB Text and Data 1 Help
LINEST Statistical 1-4 Help
LN Math and Trig 1 Help
LOG Math and Trig 1,2 Help
LOG10 Math and Trig 1 Help
LOGEST Statistical 1-4 Help
LOGINV Statistical 3 Help
LOGNORM.DIST Statistical 4 Help
LOGNORM.INV Statistical 3 Help
LOGNORMDIST Statistical 3 Help
LOOKUP Lookup and Reference 2,3 Help
LOWER Text and Data 1 Help
MATCH Lookup and Reference 2,3 Help
MAX Statistical 1+ Help
MAXA Statistical 1+ Help
MAXIFS Statistical 3+ Help
MDETERM Math and Trig 1 Help
MEDIAN Statistical 1+ Help
MID Text and Data 3 Help
MIDB Text and Data 3 Help
MIN Statistical 1+ Help
MINA Statistical 1+ Help
MINIFS Statistical 3+ Help
MINUTE Date and Time 1 Help
MINVERSE Math and Trig 1 Help
MIRR Financial 3 Help
MMULT Math and Trig 2 Help
MOD Math and Trig 2 Help
MODE Statistical 1+ Help
MODE.SNGL Statistical 1+ Help
MONDAY.DATE.MAX monday.com 1 Help
MONDAY.DATE.MIN monday.com 1 Help
MONDAY.DATE.TIMELINE monday.com 1 Help
MONDAY.DURATION.AVG monday.com 1 Help
MONDAY.DURATION.MAX monday.com 1 Help
MONDAY.DURATION.MIN monday.com 1 Help
MONDAY.DURATION.SUM monday.com 1 Help
MONDAY.GENERAL.COUNT monday.com 1 Help
MONDAY.NUMBER.AVG monday.com 1 Help
MONDAY.NUMBER.MAX monday.com 1 Help
MONDAY.NUMBER.MIN monday.com 1 Help
MONDAY.NUMBER.SUM monday.com 1 Help
MONDAY.PEOPLE.EMAIL monday.com 1 Help
MONDAY.TIMELINE.SUM monday.com 1 Help
MONTH Date and Time 1 Help
MROUND Math and Trig 2 Help
MULTINOMIAL Math and Trig 1+ Help
MUNIT Math and Trig 1 Help
N Information 1 Help
NA Information 0 Help
NEGBINOMDIST Statistical 3 Help
NETWORKDAYS Date and Time 2-3 Help
NOMINAL Financial 2 Help
NORM.DIST Statistical 4 Help
NORM.INV Statistical 3 Help
NORM.S.DIST Statistical 1,2 Help
NORM.S.INV Statistical 1 Help
NORMDIST Statistical 4 Help
NORMINV Statistical 3 Help
NORMSDIST Statistical 1 Help
NORMSINV Statistical 1 Help
NOT Logical 1 Help
NOW Date and Time 0 Help
NPER Financial 3-5 Help
NPV Financial 2+ Help
NUMBERVALUE Text and Data 1+ Help
OCT2BIN Engineering 1,2 Help
OCT2DEC Engineering 1 Help
OCT2HEX Engineering 1,2 Help
ODD Math and Trig 1 Help
OFFSET Lookup and Reference 3-5 Help
OR Logical 1+ Help
PDURATION Financial 3 Help
PEARSON Statistical 2 Help
PERCENTILE Statistical 2 Help
PERCENTILE.INC Statistical 2 Help
PERCENTRANK Statistical 2,3 Help
PERCENTRANK.INC Statistical 2,3 Help
PERMUT Statistical 2 Help
PERMUTATIONA Statistical 2 Help
PI Math and Trig 0 Help
PMT Financial 3-5 Help
POISSON Statistical 3 Help
POISSON.DIST Statistical 3 Help
POWER Math and Trig 2 Help
PPMT Financial 4-6 Help
PRICE Financial 6,7 Help
PRICEDISC Financial 4,5 Help
PRICEMAT Financial 5,6 Help
PRODUCT Math and Trig 1+ Help
PROPER Text and Data 1 Help
PV Financial 3-5 Help
QUARTILE Statistical 2 Help
QUARTILE.INC Statistical 2 Help
QUOTIENT Math and Trig 2 Help
RADIANS Math and Trig 1 Help
RAND Math and Trig 0 Help
RANDARRAY Math and Trig 0-5 Help
RANDBETWEEN Math and Trig 2 Help
RANK Statistical 2,3 Help
RANK.EQ Statistical 2,3 Help
RATE Financial 3-6 Help
RECEIVED Financial 4-5 Help
REPLACE Text and Data 4 Help
REPLACEB Text and Data 4 Help
REPT Text and Data 2 Help
RIGHT Text and Data 1,2 Help
RIGHTB Text and Data 1,2 Help
ROMAN Math and Trig 1,2 Help
ROUND Math and Trig 2 Help
ROUNDDOWN Math and Trig 2 Help
ROUNDUP Math and Trig 2 Help
ROW Lookup and Reference -1 Help
ROWS Lookup and Reference 1 Help
RRI Financial 3 Help
RSQ Statistical 2 Help
SEARCH Text and Data 2,3 Help
SEARCHB Text and Data 2,3 Help
SEC Math and Trig 1 Help
SECH Math and Trig 1 Help
SECOND Date and Time 1 Help
SEQUENCE Math and Trig 1-4 Help
SERIESSUM Math and Trig 4 Help
SIGN Math and Trig 1 Help
SIN Math and Trig 1 Help
SINH Math and Trig 1 Help
SKEW Statistical 1+ Help
SLN Financial 3 Help
SLOPE Statistical 2 Help
SMALL Statistical 2 Help
SORT Lookup and Reference 1-4 Help
SORTBY Lookup and Reference 2+ Help
SQRT Math and Trig 1 Help
SQRTPI Math and Trig 1 Help
STANDARDIZE Statistical 3 Help
STDEV Statistical 1+ Help
STDEV.P Statistical 1+ Help
STDEV.S Statistical 1+ Help
STDEVA Statistical 1+ Help
STDEVP Statistical 1+ Help
STDEVPA Statistical 1+ Help
STEYX Statistical 2 Help
SUBSTITUTE Text and Data 3,4 Help
SUBTOTAL Math and Trig 2+ Help
SUM Math and Trig 1+ Help
SUMIF Math and Trig 2,3 Help
SUMIFS Math and Trig 3+ Help
SUMPRODUCT Math and Trig 1+ Help
SUMSQ Math and Trig 1+ Help
SUMX2MY2 Math and Trig 2 Help
SUMX2PY2 Math and Trig 2 Help
SUMXMY2 Math and Trig 2 Help
SWITCH Logical 3+ Help
SYD Financial 4 Help
T Text and Data 1 Help
T.DIST Statistical 3 Help
T.DIST.2T Statistical 2 Help
T.DIST.RT Statistical 2 Help
T.INV Statistical 2 Help
T.INV.2T Statistical 2 Help
TAKE Lookup and Reference 2-3 Help
TAN Math and Trig 1 Help
TANH Math and Trig 1 Help
TBILLEQ Financial 3 Help
TBILLPRICE Financial 3 Help
TBILLYIELD Financial 3 Help
TDIST Statistical 3 Help
TEXT Text and Data 2 Help
TEXTAFTER Text and Data 2-6 Help
TEXTBEFORE Text and Data 2-6 Help
TEXTJOIN Text and Data 3+ Help
TEXTSPLIT Text and Data 2-6 Help
TIME Date and Time 3 Help
TIMEVALUE Date and Time 1 Help
TINV Statistical 2 Help
TOCOL Lookup and Reference 1-3 Help
TODAY Date and Time 0 Help
TOROW Lookup and Reference 1-3 Help
TRANSPOSE Lookup and Reference 1 Help
TREND Statistical 1-4 Help
TRIM Text and Data 1 Help
TRIMMEAN Statistical 2 Help
TRUE Logical 0 Help
TRUNC Math and Trig 1,2 Help
TYPE Information 1 Help
UNICHAR Text and Data 1 Help
UNICODE Text and Data 1 Help
UNIQUE Lookup and Reference 1+ Help
UPPER Text and Data 1 Help
USDOLLAR Financial 2 Help
VALUE Text and Data 1 Help
VALUETOTEXT Text and Data 1,2 Help
VAR Statistical 1+ Help
VAR.P Statistical 1+ Help
VAR.S Statistical 1+ Help
VARA Statistical 1+ Help
VARP Statistical 1+ Help
VARPA Statistical 1+ Help
VLOOKUP Lookup and Reference 3,4 Help
VSTACK Lookup and Reference 1+ Help
WEBSERVICE Web 1 Help
WEEKDAY Date and Time 1,2 Help
WEEKNUM Date and Time 1,2 Help
WEIBULL Statistical 4 Help
WEIBULL.DIST Statistical 4 Help
WORKDAY Date and Time 2-3 Help
XIRR Financial 2,3 Help
XLOOKUP Lookup and Reference 3-6 Help
XNPV Financial 3 Help
XOR Logical 1+ Help
YEAR Date and Time 1 Help
YEARFRAC Date and Time 2,3 Help
YIELDDISC Financial 4,5 Help
YIELDMAT Financial 5,6 Help
Z.TEST Statistical 2-3 Help
ZTEST Statistical 2-3 Help

Reading the arguments column

The arguments column tells how many values a function takes: 1 exactly one, 2,3 two or three, 1+ one or more, 0 none (like TODAY()).

Most used with monday.com

  • Logic: IF, IFS, SWITCH, AND, OR, IFERROR
  • Text: CONCATENATE, LEFT, RIGHT, MID, FIND, SUBSTITUTE, TRIM, UPPER
  • Dates: DATEVALUE, TEXT, TODAY, WORKDAY, NETWORKDAYS, EOMONTH, WEEKDAY
  • Numbers: ROUND, ROUNDUP, MOD, MIN, MAX, ABS

Something unclear or missing? Tell us and we'll improve this page.