This project has moved. For the latest updates, please go here.
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



Last edited Jul 15, 2016 at 10:50 AM by swmal, version 7