List of Worksheet Functions Available to Visual Basic

  • 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.

AccrInt

AccrIntM

Acos

Acosh

AmorDegrc

AmorLinc

And

Application

Asc

Asin

Asinh

Atan2

Atanh

AveDev

Average

AverageIf

AverageIfs

BahtText

BesselI

BesselJ

BesselK

BesselY

BetaDist

BetaInv

Bin2Dec

Bin2Hex

Bin2Oct

BinomDist

Ceiling

ChiDist

ChiInv

ChiTest

Choose

Clean

Combin

Complex

Confidence

Convert

Correl

Cosh

Count

CountA

CountBlank

CountIf

CountIfs

CoupDayBs

CoupDays

CoupDaysNc

CoupNcd

CoupNum

CoupPcd

Covar

Creator

CritBinom

CumIPmt

CumPrinc

DAverage

Days360

Db

Dbcs

DCount

DCountA

Ddb

Dec2Bin

Dec2Hex

Dec2Oct

Degrees

Delta

DevSq

DGet

Disc

DMax

DMin

Dollar

DollarDe

DollarFr

DProduct

DStDev

DStDevP

DSum

Duration

DVar

DVarP

EDate

Effect

EoMonth

Erf

ErfC

Even

ExponDist

Fact

FactDouble

FDist

Find

FindB

FInv

Fisher

FisherInv

Fixed

Floor

Forecast

Frequency

FTest

Fv

FVSchedule

GammaDist

GammaInv

GammaLn

Gcd

GeoMean

GeStep

Growth

HarMean

Hex2Bin

Hex2Dec

Hex2Oct

HLookup

HypGeomDist

IfError

ImAbs

Imaginary

ImArgument

ImConjugate

ImCos

ImDiv

ImExp

ImLn

ImLog10

ImLog2

ImPower

ImProduct

ImReal

ImSin

ImSqrt

ImSub

ImSum

Index

Intercept

IntRate

Ipmt

Irr

IsErr

IsError

IsEven

IsLogical

IsNA

IsNonText

IsNumber

IsOdd

Ispmt

IsText

Kurt

Large

Lcm

LinEst

Ln

Log

Log10

LogEst

LogInv

LogNormDist

Lookup

Match

Max

MDeterm

MDuration

Median

Min

MInverse

MIrr

MMult

Mode

MRound

MultiNomial

NegBinomDist

NetworkDays

Nominal

NormDist

NormInv

NormSDist

NormSInv

NPer

Npv

Oct2Bin

Oct2Dec

Oct2Hex

Odd

OddFPrice

OddFYield

OddLPrice

OddLYield

Or

Parent

Pearson

Percentile

PercentRank

Permut

Phonetic

Pi

Pmt

Poisson

Power

Ppmt

Price

PriceDisc

PriceMat

Prob

Product

Proper

Pv

Quartile

Quotient

Radians

RandBetween

Rank

Rate

Received

Replace

ReplaceB

Rept

Roman

Round

RoundDown

RoundUp

RSq

RTD

Search

SearchB

SeriesSum

Sinh

Skew

Sln

Slope

Small

SqrtPi

Standardize

StDev

StDevP

StEyx

Substitute

Subtotal

Sum

SumIf

SumIfs

SumProduct

SumSq

SumX2MY2

SumX2PY2

SumXMY2

Syd

Tanh

TBillEq

TBillPrice

TBillYield

TDist

Text

TInv

Transpose

Trend

Trim

TrimMean

TTest

USDollar

Var

VarP

Vdb

VLookup

Weekday

WeekNum

Weibull

WorkDay

Xirr

Xnpv

YearFrac

YieldDisc

YieldMat

ZTest