List of Worksheet Functions Available to Visual Basic [Excel 2003 VBA Language Reference]

  • Article

The following list represents all of the worksheet functions that can be called using the WorkSheetFunction object. For more information on a particular function, see the Function Reference topic on Microsoft Office Online.

Acos

Acosh

And

Asc

Asin

Asinh

Atan2

Atanh

AveDev

Average

BahtText

BetaDist

BetaInv

BinomDist

Ceiling

ChiDist

ChiInv

ChiTest

Choose

Clean

Combin

Confidence

Correl

Cosh

Count

CountA

CountBlank

CountIf

Covar

CritBinom

DAverage

Days360

Db

DCount

DCountA

Ddb

Degrees

DevSq

DGet

DMax

DMin

Dollar

DProduct

DStDev

DStDevP

DSum

DVar

DVarP

Even

ExponDist

Fact

FDist

Find

FindB

FInv

Fisher

FisherInv

Fixed

Floor

Forecast

Frequency

FTest

Fv

GammaDist

GammaInv

GammaLn

GeoMean

Growth

HarMean

HLookup

HypGeomDist

Index

Intercept

Ipmt

Irr

IsErr

IsError

IsLogical

IsNA

IsNonText

IsNumber

Ispmt

IsText

Kurt

Large

LinEst

Ln

Log

Log10

LogEst

LogInv

LogNormDist

Lookup

Match

Max

MDeterm

Median

Min

MInverse

MIrr

MMult

Mode

NegBinomDist

NormDist

NormInv

NormSDist

NormSInv

NPer

Npv

Odd

Or

Pearson

Percentile

PercentRank

Permut

Phonetic

Pi

Pmt

Poisson

Power

Ppmt

Prob

Product

Proper

Pv

Quartile

Radians

Rank

Rate

Replace

ReplaceB

Rept

Roman

Round

RoundDown

RoundUp

RSq

RTD

Search

SearchB

Sinh

Skew

Sln

Slope

Small

Standardize

StDev

StDevP

StEyx

Substitute

Subtotal

Sum

SumIf

SumProduct

SumSq

SumX2MY2

SumX2PY2

SumXMY2

Syd

Tanh

TDist

Text

TInv

Transpose

Trend

Trim

TrimMean

TTest

USDollar

Var

VarP

Vdb

VLookup

Weekday

Weibull

ZTest