Excel Automation Brick Formulas

List of the supported functions

Compatibility

Function	Supported
FLOOR	•

Date and Time

Function	Supported
DATE	•
DATEDIF	•
DATEVALUE
DAY	•
DAYS	•
EDATE	•
EOMONTH	•
HOUR
ISOWEEKNUM	•
MINUTE
MONTH	•
NOW	•
SECOND
TIME
TIMEVALUE
TODAY	•
WEEKDAY	•
YEAR	•
YEARFRAC	•

Engineering

Function	Supported
BIN2DEC	•
BIN2HEX	•
BIN2OCT	•
DEC2BIN	•
DEC2HEX	•
DEC2OCT	•
HEX2BIN	•
HEX2DEC	•
HEX2OCT	•
OCT2BIN	•
OCT2DEC	•
OCT2HEX	•

Financial

Function	Supported
IRR	•
NPV	•
PMT	•
PV	•
SLN	•
VDB	•
XIRR	•
XNPV	•

Information

Function	Supported
ISBLANK	•
ISERR	•
ISERROR	•
ISEVEN	•
ISNA	•
ISNUMBER	•
ISODD	•
ISTEXT	•
NA	•

Logical

Function	Supported
AND	•
FALSE	•
IF	•
IFERROR
IFS
NOT
OR	•
SWITCH
TRUE	•
XOR

Lookup and reference

Function	Supported
CHOOSE	•
COLUMN
COLUMNS
HLOOKUP
INDEX
INDIRECT
LOOKUP
MATCH	•
OFFSET
ROW
ROWS
VLOOKUP	•

Math and Trigonometry

Function	Supported
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	Supported
AVERAGE	•
AVERAGEA
AVERAGEIF
AVERAGEIFS
COUNT	•
COUNTA	•
COUNTBLANK
COUNTIF	•
COUNTIFS	•
LARGE
LINEST
MAX	•
MAXA
MAXIFS
MIN	•
MINA
MINIFS
SMALL

Text

Function	Supported
CONCAT	•
CONCATENATE	•
EXACT	•
FIND	•
LEFT	•
LEN	•
LOWER	•
MID	•
REPLACE	•
RIGHT	•
TRIM	•
UPPER	•
VALUE