Supported functions

The complete list of functions supported in Equals formulas

Ben McRedmond avatar
Written by Ben McRedmond
Updated over a week ago

Date and time

  • DATE

  • DATEDIF

  • DATEVALUE

  • DAY

  • DAYS

  • EDATE

  • EOMONTH

  • HOUR

  • MINUTE

  • MONTH

  • NETWORKDAYS

  • NOW

  • SOWEEK

  • TIME

  • TIMEVALUE

  • TODAY

  • WEEKDAY

  • WEEKNUM

  • WORKDAY

  • YEAR

  • YEARFRAC

Financial

  • IRR

  • NPV

  • PMT

Information

  • CELL

  • TYPE

Logical

  • AND

  • FALSE

  • IF

  • IFERROR

  • IFNA

  • IFS

  • NOT

  • OR

  • TRUE

  • ISBLANK

  • ISERROR

  • ISNUMBER

Lookup

  • ADDRESS

  • CHOOSE

  • COLUMN

  • COLUMNS

  • HLOOKUP

  • INDEX

  • JSONLOOKUP

  • LOOKUP

  • MATCH

  • ROW

  • ROWS

  • SORT

  • SORTBY

  • VLOOKUP

Math

  • ABS

  • EVEN

  • FLOOR

  • INT

  • LOG

  • MOD

  • ODD

  • PRODUCT

  • QUOTIENT

  • RAND

  • RANDBETWEEN

  • ROUND

  • ROUNDDOWN

  • ROUNDUP

  • SQRT

  • SUM

  • SUMIF

  • SUMIFS

  • SUMPRODUCT

  • TRUNC

Statistical

  • AVERAGE

  • AVERAGEIF

  • AVERAGEIFS

  • CHISQ.TEST

  • COUNT

  • COUNTA

  • COUNTBLANK

  • COUNTIF

  • COUNTIFS

  • COUNTUNIQUEIFS

  • FORECAST

  • MAX

  • MAXIFS

  • MEAN

  • MEDIAN

  • MIN

  • MINIFS

  • NORM.DIST

  • PERCENTILE

  • PERCENTILE.EXC

  • PERCENTILE.INC

  • QUARTILE

  • QUARTILE.EXC

  • QUARTILE.INC

  • RANK

  • STDEV

  • T.TEST

Text

  • CHAR

  • CLEAN

  • CONCAT

  • CONCATENATE

  • EXACT

  • FIND

  • LEFT

  • LEN

  • LOWER

  • REGEXMATCH

  • RIGHT

  • MID

  • SEARCH

  • SUBSTITUTE

  • TEXT

  • TEXTAFTER

  • TRIM

  • UPPER

  • VALUE

Did this answer your question?