Skip to content
This repository has been archived by the owner on Mar 9, 2020. It is now read-only.

Supported Functions

Jan Källman edited this page Aug 31, 2017 · 1 revision

The following functions are supported by EPPlus 4.1.0 when evaluating formulas:

  • 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