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

BESSELY

BETA.DIST

BETA.INV

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

COMBINA

COMPLEX

CONCAT

CONCATENATE

CONFIDENCE.NORM

CONFIDENCE.T

CORREL

COS

COSH

COT

COTH

COUNT

COUNTA

COUNTBLANK

COUNTIF

COUNTIFS

COVARIANCE.P

COVARIANCE.S

CSC

CSCH

CUMIPMT

CUMPRINC

D

DATE

DATEDIF

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

ENCODEURL

EOMONTH

ERF

ERF.PRECISE

ERFC

ERFC.PRECISE

ERROR.TYPE

EVEN

EXACT

EXP

EXPON.DIST

EXPONDIST

F

F.INV.RT

FACT

FACTDOUBLE

FALSE

FIND

FISHER

FISHERINV

FIXED

FLOOR

FLOOR.MATH

FLOOR.PRECISE

FORECAST

FORMULATEXT

FV

FVSCHEDULE

G

GAMMA.DIST

GAMMA.INV

GAMMADIST

GAMMAINV

GAMMALN

GAMMALN.PRECISE

GAUSS

GCD

GEOMEAN

GESTEP

H

HARMEAN

HEX2BIN

HEX2DEC

HEX2OCT

HLOOKUP

HOUR

HYPERLINK

HYPGEOM.DIST

HYPGEOMDIST

I

IF

IFERROR

IFS

IFNA

IMABS

IMAGINARY

IMARGUMENT

IMCONJUGATE

IMCOS

IMCOSH

IMCSC

IMCSCH

IMDIV

IMEXP

IMLN

IMLOG10

IMLOG2

IMPRODUCT

IMREAL

IMSEC

IMSECH

IMSIN

IMSINH

IMSQRT

IMSUB

IMSUM

IMTAN

INDEX

INDIRECT

INT

INTERCEPT

IPMT

IRR

ISBLANK

ISERR

ISERROR

ISEVEN

ISFORMULA

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

MAXIFS

MDETERM

MEDIAN

MID

MIN

MINA

MINIFS

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

PERCENTRANK

PERCENTRANK.EXC

PERCENTRANK.INC

PERMUT

PERMUTATIONA

PHI

PI

PMT

POISSON

POISSON.DIST

POWER

PPMT

PROB

PRODUCT

PROPER

PV

Q

QUARTILE.EXC

QUARTILE.INC

QUOTIENT

R

RADIANS

RAND

RANDARRAY

RANDBETWEEN

RANK

RANK.AVG

RANK.EQ

RATE

REPLACE

REPT

RIGHT

ROMAN

ROUND

ROUNDDOWN

ROUNDUP

ROW

ROWS

RRI

RSQ

S

SEARCH

SEC

SECH

SECOND

SEQUENCE

SERIESSUM

SIGN

SIN

SINGLE

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

T.DIST

T.DIST.2T

T.DIST.RT

T.INV

T.INV.2T

TAN

TANH

TDIST

TEXT

TEXTJOIN

TIME

TIMEVALUE

TODAY

TREND

TRIM

TRIMMEAN

TRUE

TRUNC

TYPE

U

UPPER

UNICHAR

UNICODE

UNIQUE

V

VALUE

VAR

VAR.P

VAR.S

VARA

VARP

VARPA

VLOOKUP

W

WEEKDAY

WEEKNUM

WEIBULL

WEIBULL.DIST

WORKDAY

WORKDAY.INTL

X

XNPV

XOR

Y

YEAR

YEARFRAC