support_functions.rst

Supported Functions

Compatibility

Function	xlsx_evaluate	PyCel	formulas	Koala
FLOOR

Date and Time

Function	xlsx_evaluate	PyCel	formulas	Koala
DATE
DATEDIF
DATEVALUE
DAY
DAYS
EDATE
EOMONTH
HOUR
ISOWEEKNUM
MINUTE
MONTH
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
YEAR
YEARFRAC

Engineering

Function	xlsx_evaluate	PyCel	formulas	Koala
BIN2DEC
BIN2HEX
BIN2OCT
DEC2BIN
DEC2HEX
DEC2OCT
HEX2BIN
HEX2DEC
HEX2OCT
OCT2BIN
OCT2DEC
OCT2HEX

Financial

Function	xlsx_evaluate	PyCel	formulas	Koala
IRR
NPV
PMT
PV
SLN
VDB
XIRR
XNPV

Information

Function	xlsx_evaluate	PyCel	formulas	Koala
ISBLANK
ISERR
ISERROR
ISEVEN
ISNA
ISNUMBER
ISODD
ISTEXT
NA

Logical

Function	xlsx_evaluate	PyCel	formulas	Koala
AND
FALSE
IF
IFERROR
IFS
NOT
OR
SWITCH
TRUE
XOR

Lookup and reference

Function	xlsx_evaluate	PyCel	formulas	Koala
CHOOSE
COLUMN
COLUMNS
HLOOKUP
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW
ROWS
VLOOKUP

Math and Trigonometry

Function	xlsx_evaluate	PyCel	formulas	Koala
ABS
ACOS
ACOSH
ACOT
ACOTH
ARABIC
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
CEILING.MATH
CEILING.PRECISE
COS
COSH
COT
COTH
CSC
CSCH
DECIMAL
DEGREES
EVEN
EXP
FACT
FACTDOUBLE
FLOOR.MATH
FLOOR.PRECISE
GCD
INT
ISO.CEILING
LCM
LN
LOG
LOG10
MOD
MROUND
ODD
PI
POWER
RADIANS
RAND
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SEC
SECH
SIGN
SIN
SINH
SQRT
SQRTPI
SUM
SUMIF
SUMIFS
SUMPRODUCT
TAN
TANH
TRUNC

Statistical

Function	xlsx_evaluate	PyCel	formulas	Koala
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
LARGE
LINEST
MAX
MAXA
MAXIFS
MIN
MINA
MINIFS
SMALL

Text

Function	xlsx_evaluate	PyCel	formulas	Koala
CONCAT
CONCATENATE
EXACT
FIND
LEFT
LEN
LOWER
MID
REPLACE
RIGHT
TRIM
UPPER
VALUE