List of Worksheet Functions Available to Visual Basic
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
A
Acos
Acosh
And
Asin
Asinh
Atan2
Atanh
AveDev
Average
B
BetaDist
BetaInv
BinomDist
C
Ceiling
ChiDist
ChiInv
ChiTest
Choose
Clean
Combin
Confidence
Correl
Cosh
Count
CountA
CountBlank
CountIf
Covar
CritBinom
D
DAverage
Days360
Db
DCount
DCountA
Ddb
Degrees
DevSq
DGet
DMax
DMin
Dollar
DProduct
DStDev
DStDevP
DSum
DVar
DVarP
E
Even
ExponDist
F
Fact
FDist
Find
FindB
FInv
Fisher
FisherInv
Fixed
Floor
Forecast
Frequency
FTest
Fv
G
GammaDist
GammaInv
GammaLn
GeoMean
Growth
H
HarMean
HLookup
HypGeomDist
I
Index
Intercept
Ipmt
Irr
IsErr
IsError
IsLogical
IsNA
IsNonText
IsNumber
Ispmt
IsText
J
K
Kurt
L
Large
LinEst
Ln
Log
Log10
LogEst
LogInv
LogNormDist
Lookup
M
Match
Max
MDeterm
Median
Min
MInverse
MIrr
MMult
Mode
N
NegBinomDist
NormDist
NormInv
NormSDist
NormSInv
NPer
Npv
O
Odd
Or
P
Pearson
Percentile
PercentRank
Permut
Phonetic
Pi
Pmt
Poisson
Power
Ppmt
Prob
Product
Proper
Pv
Q
Quartile
R
Radians
Rank
Rate
Replace
ReplaceB
Rept
Roman
Round
RoundDown
RoundUp
RSq
S
Search
SearchB
Sinh
Skew
Sln
Slope
Small
Standardize
StDev
StDevP
StEyx
Substitute
Subtotal
Sum
SumIf
SumProduct
SumSq
SumX2MY2
SumX2PY2
SumXMY2
Syd
T
Tanh
TDist
Text
TInv
Transpose
Trend
Trim
TrimMean
TTest
U
USDollar
V
Var
VarP
Vdb
VLookup
W
Weekday
Weibull
X
Y
Z
ZTest