可用于 Visual Basic 的工作表函数列表
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
RTD
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