VBA or Excel

The following table lists all the Excel worksheet functions which are available.
For a general rule, if there is an identical VBA Function then the Excel function is not available.
It also highlights when there is an alternative VBA Functions.
The asterisk denotes when the VBA function has a different name to the Excel function.
For more information refer to support.microsoft.com

FunctionExcel
(WorksheetFunction.)
VBA
(VBA.)
ABSABSABS
ACCRINTACCRINT 
ACCRINTMACCRINTM 
ACOSACOS 
ACOSHACOSH 
ACOTACOT 
ACOTHACOTH 
ADDRESSADDRESS 
AGGREGATEAGGREGATE 
AMORDEGRCAMORDEGRC 
AMORLINCAMORLINC 
ANDANDAND
ARABICARABIC 
AREASAREAS 
ASCASCASC
ASINASIN 
ASINHASINH 
ATAN*ATANATN
ATAN2ATAN2 
ATANHATANH 
ATN*ATANATN
AVEDEVAVEDEV 
AVERAGEAVERAGE 
AVERAGEAAVERAGEA 
AVERAGEIFAVERAGEIF 
AVERAGEIFSAVERAGEIFS 
BAHTTEXTBAHTTEXT 
BASEBASE 
BESSELIBESSELI 
BESSELJBESSELJ 
BESSELKBESSELK 
BESSELYBESSELY 
BETA.DISTBETA.DIST 
BETA.INVBETA.INV 
BIN2DECBIN2DEC 
BIN2HEXBIN2HEX 
BIN2OCTBIN2OCT 
BINOM.DISTBINOM.DIST 
BINOM.DIST.RANGEBINOM.DIST.RANGE 
BINOM.INVBINOM.INV 
BITANDBITAND 
BITLSHIFTBITLSHIFT 
BITORBITOR 
BITRSHIFTBITRSHIFT 
BITXORBITXOR 
CALLCALL 
CEILING.MATHCEILING.MATH 
CELLCELL 
CHAR*CHARCHR
CHISQ.DISTCHISQ.DIST 
CHISQ.DIST.RTCHISQ.DIST.RT 
CHISQ.INVCHISQ.INV 
CHISQ.INV.RTCHISQ.INV.RT 
CHISQ.TESTCHISQ.TEST 
CHOOSECHOOSECHOOSE
CHR*CHARCHR
CLEANCLEAN 
CODECODE 
COLUMNCOLUMN 
COLUMNSCOLUMNS 
COMBINCOMBIN 
COMBINACOMBINA 
COMMAND COMMAND
COMPLEXCOMPLEX 
CONCATENATECONCATENATE&
CONFIDENCE.NORMCONFIDENCE.NORM 
CONFIDENCE.TCONFIDENCE.T 
CONVERTCONVERT 
CORRELCORREL 
COSCOSCOS
COSHCOSH 
COTCOT 
COTHCOTH 
COUNTCOUNT 
COUNTACOUNTA 
COUNTBLANKCOUNTBLANK 
COUNTIFCOUNTIF 
COUNTIFSCOUNTIFS 
COUPDAYBSCOUPDAYBS 
COUPDAYSCOUPDAYS 
COUPDAYSNCCOUPDAYSNC 
COUPNCDCOUPNCD 
COUPNUMCOUPNUM 
COUPPCDCOUPPCD 
COVARIANCE.PCOVARIANCE.P 
COVARIANCE.SCOVARIANCE.S 
CRITBINOMCRITBINOM 
CSCCSC 
CSCHCSCH 
CUBEKPIMEMBERCUBEKPIMEMBER 
CUBEMEMBERCUBEMEMBER 
CUBESETCUBESET 
CUBESETCOUNTCUBESETCOUNT 
CUBEVALUECUBEVALUE 
CUMIPMTCUMIPMT 
CUMPRINCCUMPRINC 
DATE DATE - Function
DATE*DATEDATE - Statement
DATEADD DATEADD
DATEDIFF DATEDIFF
DATEPART DATEPART
DATESERIAL* DATESERIAL
DATEVALUE DATEVALUE
DAVERAGEDAVERAGE 
DAY DAY
DAYSDAYS 
DAYS360DAYS360 
DBDB 
DBCSDBCS 
DCOUNTDCOUNT 
DCOUNTADCOUNTA 
DDBDDBDDB
DEC2BINDEC2BIN 
DEC2HEXDEC2HEX 
DEC2OCTDEC2OCT 
DECIMALDECIMAL 
DEGREESDEGREES 
DELTADELTA 
DEVSQDEVSQ 
DGETDGET 
DISCDISC 
DMAXDMAX 
DMINDMIN 
DOLLARDOLLAR 
DOLLARDEDOLLARDE 
DOLLARFRDOLLARFR 
DPRODUCTDPRODUCT 
DSTDEVDSTDEV 
DSTDEVPDSTDEVP 
DSUMDSUM 
DURATIONDURATION 
DVARDVAR 
DVARPDVARP 
EDATEEDATE 
EFFECTEFFECT 
ENCODEURLENCODEURL 
EOMONTHEOMONTH 
ERFERF 
ERF.PRECISEERF.PRECISE 
ERFC.PRECISEERFC.PRECISE 
ERROR.TYPEERROR.TYPE 
EUROCONVERTEUROCONVERT 
EVENEVEN 
EXACTEXACT 
EXP EXP
EXPON.DISTEXPON.DIST 
F.DISTF.DIST 
F.DIST.RTF.DIST.RT 
F.INVF.INV 
F.INV.RTF.INV.RT 
F.TESTF.TEST 
FACTFACT 
FACTDOUBLEFACTDOUBLE 
FALSEFALSE 
FILTER FILTER
FILTERXMLFILTERXML 
FINDFIND 
FISHERFISHER 
FISHERINVFISHERINV 
FIX FIX
FIXEDFIXED 
FLOOR.MATHFLOOR.MATH 
FLOOR.PRECISEFLOOR.PRECISE 
FORECASTFORECAST 
FORECAST.ETSFORECAST.ETS 
FORECAST.LINEARFORECAST.LINEAR 
FORMAT FORMAT
FORMATCURRENCY FORMATCURRENCY
FORMATDATETIME FORMATDATETIME
FORMATNUMBER FORMATNUMBER
FORMATPERCENT FORMATPERCENT
FORMULATEXTFORMULATEXT 
FREQUENCYFREQUENCY 
FREQUENCYFREQUENCY 
FVFVFV
GAMMAGAMMA 
GAMMA.DISTGAMMA.DIST 
GAMMA.INVGAMMA.INV 
GAMMALN.PRECISEGAMMALN.PRECISE 
GAUSSGAUSS 
GCDGCD 
GEOMEANGEOMEAN 
GESTEPGESTEP 
GETPIVOTDATAGETPIVOTDATA 
GROWTHGROWTH 
HARMEANHARMEAN 
HEXBIN2HEXHEX
HEX2BINHEX2BIN 
HEX2DECHEX2DEC 
HEX2OCTHEX2OCT 
HLOOKUPHLOOKUP 
HOURHOURHOUR
HYPERLINKHYPERLINK 
HYPGEOM.DISTHYPGEOM.DIST 
IFIF 
IFERRORIFERROR 
IFNAIFNA 
IFSIFS 
IMABSIMABS 
IMAGINARYIMAGINARY 
IMARGUMENTIMARGUMENT 
IMCONJUGATEIMCONJUGATE 
IMCOSIMCOS 
IMCOSHIMCOSH 
IMCOTIMCOT 
IMCSCIMCSC 
IMCSCHIMCSCH 
IMDIVIMDIV 
IMEXPIMEXP 
IMLNIMLN 
IMLOG10IMLOG10 
IMLOG2IMLOG2 
IMPOWERIMPOWER 
IMPRODUCTIMPRODUCT 
IMREALIMREAL 
IMSECIMSEC 
IMSECHIMSECH 
IMSINIMSIN 
IMSINHIMSINH 
IMSQRTIMSQRT 
IMSUBIMSUB 
IMSUMIMSUM 
IMTANIMTAN 
INDEXINDEX 
INDIRECTINDIRECT 
INFOINFO 
INPUT INPUT - Function
INPUT INPUT - Statement
INSTR INSTR
INSTRREV INSTRREV
INTINTINT
INTERCEPTINTERCEPT 
INTRATEINTRATE 
IPMTIPMTIPMT
IRRIRRIRR
IS IS
ISARRAY ISARRAY
ISBLANKISBLANK 
ISDATE ISDATE
ISEMPTY ISEMPTY
ISERRISERR 
ISERRORISERRORISERROR
ISEVENISEVEN 
ISFORMULAISFORMULA 
ISLOGICALISLOGICAL 
ISMISSING ISMISSING
ISNAISNA 
ISNONTEXTISNONTEXT 
ISNULL ISNULL
ISNUMBERISNUMBER 
ISNUMERIC ISNUMERIC
ISO.CEILINGISO.CEILING 
ISOBJECT ISOBJECT
ISODDISODD 
ISOWEEKNUMISOWEEKNUM 
ISPMTISPMT 
ISREFISREF 
ISTEXTISTEXT 
JISJIS 
JOIN JOIN
KURTKURT 
LARGELARGE 
LCASE LCASE
LCMLCM 
LEFTLEFTLEFT
LENLENLEN
LINESTLINEST 
LN*LNLOG
LOG*LOG 
LOG10LOG10 
LOGESTLOGEST 
LOGNORM.DISTLOGNORM.DIST 
LOGNORM.INVLOGNORM.INV 
LOOKUPLOOKUP 
LOWERLOWER 
LSET LSET
LTRIM LTRIM
MATCHMATCH 
MAXMAX 
MAXAMAXA 
MAXIFSMAXIFS 
MDETERMMDETERM 
MDURATIONMDURATION 
MEDIANMEDIAN 
MIDMIDMID
MINMIN 
MINAMINA 
MINIFSMINIFS 
MINUTEMINUTEMINUTE
MINVERSEMINVERSE 
MIRRMIRRMIRR
MMULTMMULT 
MODMODMOD
MODE.MULTMODE.MULT 
MODE.SNGLMODE.SNGL 
MONTHMONTHMONTH
MONTHNAME MONTHNAME
MROUNDMROUND 
MULTINOMIALMULTINOMIAL 
MUNITMUNIT 
NN 
NANA 
NEGBINOM.DISTNEGBINOM.DIST 
NETWORKDAYS.INTLNETWORKDAYS.INTL 
NOMINALNOMINAL 
NORM.DISTNORM.DIST 
NORM.INVNORM.INV 
NORM.S.DISTNORM.S.DIST 
NORM.S.INVNORM.S.INV 
NOTNOT 
NOWNOWNOW
NPERNPERNPER
NPVNPVNPV
NUMBERVALUENUMBERVALUE 
OCTOCT2BINOCT
OCT2BINOCT2BIN 
OCT2DECOCT2DEC 
OCT2HEXOCT2HEX 
ODDODD 
ODDFPRICEODDFPRICE 
ODDFYIELDODDFYIELD 
ODDLPRICEODDLPRICE 
ODDLYIELDODDLYIELD 
OFFSETOFFSET 
OROROR
PARTITION PARTITION
PDURATIONPDURATION 
PEARSONPEARSON 
PERCENTILE.EXCPERCENTILE.EXC 
PERCENTILE.INCPERCENTILE.INC 
PERCENTRANK.EXCPERCENTRANK.EXC 
PERCENTRANK.INCPERCENTRANK.INC 
PERMUTPERMUT 
PERMUTATIONAPERMUTATIONA 
PHIPHI 
PHONETICPHONETIC 
PIPI 
PMTPMTPMT
POISSON.DISTPOISSON.DIST 
POWERPOWER 
PPMTPPMTPPMT
PRICEPRICE 
PRICEDISCPRICEDISC 
PRICEMATPRICEMAT 
PROBPROB 
PRODUCTPRODUCT 
PROPERPROPER 
PUT PUT
PVPVPV
QBCOLOR QBCOLOR
QUARTILE.EXCQUARTILE.EXC 
QUARTILE.INCQUARTILE.INQ 
QUOTIENTQUOTIENT 
RADIANSRADIANS 
RAND*RANDRND
RANDBETWEENRANDBETWEEN 
RANK.AVGRANK.AVG 
RANK.EQRANK.EQ 
RATERATERATE
RECEIVEDRECEIVED 
REPLACEREPLACEREPLACE
REPTREPT 
RIGHTRIGHTRIGHT
RND*RANDRND
ROMANROMAN 
ROUNDROUNDROUND
ROUNDDOWNROUNDDOWN 
ROUNDUPROUNDUP 
ROWROW 
ROWSROWS 
RRIRRI 
RSET RSET
RSQRSQ 
RTDRTD 
RTRIM RTRIM
SEARCHSEARCH 
SECSEC 
SECHSECH 
SECONDSECONDSECOND
SENDKEYS SENDKEYS
SERIESSUMSERIESSUM 
SETATTR SETATTR
SGN*SIGNSGN
SHEETSHEET 
SHEETSSHEETS 
SHELL SHELL
SIGN*SIGNSGN
SINSINSIN
SINHSINH 
SKEWSKEW 
SKEW.PSKEW.P 
SLNSLNSLN
SLOPESLOPE 
SMALLSMALL 
SPACE SPACE
SPLIT SPLIT
SQR*SQRTSQR
SQRT*SQRTSQR
SQRTPISQRTPI 
STANDARDIZESTANDARDIZE 
STDEV.PSTDEV.P 
STDEV.SSTDEV.S 
STDEVASTDEVA 
STDEVPASTDEVPA 
STEYXSTEYX 
STR STR
STRCOMP STRCOMP
STRCONV STRCONV
STRING STRING
STRREVERSE STRREVERSE
SUBSTITUTESUBSTITUTE 
SUBTOTALSUBTOTAL 
SUMSUMApplication.SUM ?
SUMIFSUMIF 
SUMIFSSUMIFS 
SUMPRODUCTSUMPRODUCT 
SUMSQSUMSQ 
SUMX2MY2SUMX2MY2 
SUMX2PY2SUMX2PY2 
SUMXMY2SUMXMY2 
SWITCHSWITCH 
SYDSYDSYD
TT 
T.DISTT.DIST 
T.DIST.2TT.DIST.2T 
T.DIST.RTT.DIST.RT 
T.INVT.INV 
T.INV.2TT-INV-2T 
T.TESTT.TEST 
TAN TAN
TANHTANH 
TBILLEQTBILLEQ 
TBILLPRICETBILLPRICE 
TBILLYIELDTBILLYIELD 
TEXTTEXT 
TEXTJOINTEXTJOIN 
TIME TIME - Function
TIME TIME - Statement
TIMER TIMER
TIMESERIAL TIMESERIAL
TIMEVALUE TIMEVALUE
TODAY*TODAYDATE - Function
TRANSPOSETRANSPOSE 
TRENDTREND 
TRIMTRIMTRIM
TRIMMEANTRIMMEAN 
TRUETRUE 
TRUNCTRUNC 
TYPETYPE 
UNICHARUNICHAR 
UNICODEUNICODE 
UPPER*UPPERUCASE
VAL VAL
VALUEVALUE 
VAR.PVAR.P 
VAR.SVAR.S 
VARAVARA 
VARPAVARPA 
VDBVDB 
VLOOKUPVLOOKUP 
WEBSERVICEWEBSERVICE 
WEEKDAYWEEKDAYWEEKDAY
WEEKDAYNAME WEEKDAYNAME
WEEKNUMWEEKNUM 
WEIBULL.DISTWEIBULL.DIST 
WORKDAY.INTLWORKDAY.INTL 
XIRRXIRR 
XNPVXNPV 
XORXOR 
YEARYEARYEAR
YEARFRACYEARFRAC 
YIELDYIELD 
YIELDDISCYIELDDISC 
YIELDMATYIELDMAT 
Z.TESTZ-TEST 

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext