Supported Excel Functions

AlchemyJ supports 300+ built-in Excel functions. There will be more functions that will be supported in the upcoming version.

A B C D E F G H I K L M N O P Q R S T U V W X Y

A

ABS

ACOS

ACOSH

ACOT

ACOTH

ADDRESS

AND

ARABIC

AREAS

ASIN

ASINH

ATAN

ATAN2

ATANH

AVEDEV

AVERAGE

AVERAGEA

AVERAGEIF

AVERAGEIFS

B

BASE

BIN2DEC

BIN2HEX

BIN2OCT

BINOM.DIST

BINOM.DIST.RANGE

BINOM.INV

BITAND

BITLSHIFT

BITOR

BITRSHIFT

BITXOR

C

CEILING

CEILING.MATH

CEILING.PRECISE

CHAR

CHISQ.DIST

CHISQ.DIST.RT

CHISQ.TEST

CHOOSE

CLEAN

CODE

COLUMN

COLUMNS

COMBIN

COMPLEX

CONCAT

CONCATENATE

CONFIDENCE.NORM

CORREL

COS

COSH

COT

COTH

COUNT

COUNTA

COUNTBLANK

COUNTIF

COUNTIFS

COVARIANCE.P

COVARIANCE.S

CSC

CSCH

CUMIPMT

D

DATE

DATEVALUE

DAVERAGE

DAY

DAYS

DAYS360

DB

DCOUNT

DCOUNTA

DDB

DEC2BIN

DEC2HEX

DEC2OCT

DECIMAL

DEGREES

DELTA

DEVSQ

DGET

DMAX

DMIN

DOLLAR

DOLLARDE

DOLLARFR

DPRODUCT

DSTDEV

DSTDEVP

DSUM

DVAR

DVARP

E

EDATE

EFFECT

EOMONTH

ERF

ERF.PRECISE

ERFC

ERFC.PRECISE

ERROR.TYPE

EVEN

EXACT

EXP

EXPON.DIST

EXPONDIST

F

FACT

FACTDOUBLE

FALSE

FIND

FISHER

FISHERINV

FIXED

FLOOR

FLOOR.MATH

FLOOR.PRECISE

FORECAST

FV

FVSCHEDULE

G

GAMMA.DIST

GAMMADIST

GAMMALN

GAMMALN.PRECISE

GAUSS

GCD

GEOMEAN

GESTEP

H

HARMEAN

HEX2BIN

HEX2DEC

HEX2OCT

HLOOKUP

HOUR

HYPERLINK

HYPGEOM.DIST

HYPGEOMDIST

I

IF

IFERROR

IFNA

IMABS

IMAGINARY

IMARGUMENT

IMCONJUGATE

IMDIV

IMLN

IMLOG10

IMLOG2

IMPRODUCT

IMREAL

IMSQRT

IMSUB

IMSUM

IMTAN

INDEX

INDIRECT

INT

INTERCEPT

IPMT

IRR

ISBLANK

ISERR

ISERROR

ISEVEN

ISLOGICAL

ISNA

ISNONTEXT

ISNUMBER

ISO.CEILING

ISODD

ISOWEEKNUM

ISPMT

ISREF

ISTEXT

K

KURT

L

LARGE

LCM

LEFT

LEN

LN

LOG

LOG10

LOGNORM.DIST

LOGNORM.INV

LOGNORMDIST

LOOKUP

LOWER

M

MATCH

MAX

MAXA

MDETERM

MEDIAN

MID

MIN

MINA

MINUTE

MIRR

MOD

MODE

MODE.MULT

MODE.SNGL

MONTH

MROUND

MULTINOMIAL

MUNIT

N

N

NA

NEGBINOM.DIST

NEGBINOMDIST

NETWORKDAYS

NETWORKDAYS.INTL

NOMINAL

NORM.DIST

NORM.INV

NORM.S.DIST

NORM.S.INV

NORMDIST

NORMINV

NORMSDIST

NORMSINV

NOT

NOW

NPER

NPV

NUMBERVALUE

O

OCT2BIN

OCT2DEC

OCT2HEX

ODD

OFFSET

OR

P

PDURATION

PEARSON

PERCENTILE

PERCENTILE.EXC

PERCENTILE.INC

PERMUT

PERMUTATIONA

PHI

PI

PMT

POISSON

POISSON.DIST

POWER

PPMT

PROB

PRODUCT

PROPER

PV

Q

QUOTIENT

R

RADIANS

RAND

RANDBETWEEN

RANK

RANK.AVG

RANK.EQ

RATE

REPLACE

REPT

RIGHT

ROMAN

ROUND

ROUNDDOWN

ROUNDUP

ROW

ROWS

RRI

RSQ

S

SEARCH

SEC

SECH

SECOND

SIGN

SIN

SINH

SKEW

SKEW.P

SLN

SLOPE

SMALL

SQRT

SQRTPI

STANDARDIZE

STDEV

STDEV.P

STDEV.S

STDEVA

STDEVP

STDEVPA

STEYX

SUBSTITUTE

SUBTOTAL

SUM

SUMIF

SUMIFS

SUMPRODUCT

SUMSQ

SUMX2MY2

SUMX2PY2

SUMXMY2

SWITCH

SYD

T

T

TAN

TANH

TEXT

TIME

TIMEVALUE

TODAY

TREND

TRIM

TRIMMEAN

TRUE

TRUNC

TYPE

U

UPPER

V

VALUE

VAR

VAR.P

VAR.S

VARA

VARP

VARPA

VLOOKUP

W

WEEKDAY

WEEKNUM

WORKDAY

X

XNPV

XOR

Y

YEAR

YEARFRAC