可用于 Visual Basic 的工作表函数列表
以下列表表示可以使用 WorkSheetFunction 对象调用的所有工作表函数。
有关某个特定函数的详细信息,请参阅 Excel 函数(按类别)主题。
- AccrInt
- AccrIntM
- Acos
- Acosh
- Aggregate
- AmorDegrc
- AmorLinc
- And
- 应用程序
- Asc
- Asin
- Asinh
- Atan2
- Atanh
- AveDev
- 平均
- AverageIf
- AverageIfs
- BahtText
- BesselI
- BesselJ
- BesselK
- BesselY
- BetaDist
- BetaInv
- Bin2Dec
- Bin2Hex
- Bin2Oct
- Binom_Dist
- Binom_Inv
- BinomDist
- Ceiling
- Ceiling_Precise
- ChiDist
- ChiInv
- ChiSq_Dist
- ChiSq_Dist_RT
- ChiSq_Inv
- ChiSq_Inv_RT
- ChiSq_Test
- ChiTest
- Choose
- 清理
- Combin
- 复杂
- Confidence
- Confidence_Norm
- Confidence_T
- 转换
- Correl
- Cosh
- Count
- CountA
- CountBlank
- CountIf
- CountIfs
- CoupDayBs
- CoupDays
- CoupDaysNc
- CoupNcd
- CoupNum
- CoupPcd
- Covar
- Covariance_P
- Covariance_S
- 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
- 持续时间
- DVar
- DVarP
- EDate
- 效果
- EoMonth
- Erf
- Erf_Precise
- ErfC
- Even
- Expon_Dist
- ExponDist
- F_Dist
- F_Dist_RT
- F_Inv
- F_Inv_RT
- F_Test
- Fact
- FactDouble
- FDist
- 查找
- FindB
- FInv
- Fisher
- FisherInv
- Fixed
- Floor
- 预测
- 频率
- FTest
- Fv
- FVSchedule
- Gamma_Dist
- Gamma_Inv
- GammaDist
- GammaInv
- GammaLn
- GammaLn_Precise
- Gcd
- GeoMean
- GeStep
- Growth
- HarMean
- Hex2Bin
- Hex2Dec
- Hex2Oct
- HLookup
- HypGeom_Dist
- 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
- 大
- Lcm
- LinEst
- Ln
- Log
- Log10
- LogEst
- LogInv
- LogNorm_Dist
- LogNorm_Inv
- LogNormDist
- 查找
- Match
- Max
- MDeterm
- MDuration
- Median
- Min
- MInverse
- MIrr
- MMult
- 模式
- Mode_Mult
- Mode_Sngl
- MRound
- MultiNomial
- NegBinom_Dist
- NegBinomDist
- NetworkDays
- Nominal
- Norm_Dist
- Norm_Inv
- Norm_S_Dist
- Norm_S_Inv
- NormDist
- NormInv
- NormSDist
- NormSInv
- NPer
- Npv
- Oct2Bin
- Oct2Dec
- Oct2Hex
- Odd
- OddFPrice
- OddFYield
- OddLPrice
- OddLYield
- 或者
- Pearson
- Percentile
- Percentile_Exc
- Percentile_Inc
- PercentRank
- PercentRank_Exc
- PercentRank_Inc
- Permut
- Phonetic
- Pi
- Pmt
- Poisson
- Poisson_Dist
- Power
- Ppmt
- 价格
- PriceDisc
- PriceMat
- Prob
- 产品
- Proper
- Pv
- Quartile
- Quartile_Exc
- Quartile_Inc
- Quotient
- Radians
- RandBetween
- Rank
- Rank_Avg
- Rank_Eq
- 比率
- 接收时间
- Replace
- ReplaceB
- Rept
- Roman
- Round
- RoundDown
- RoundUp
- RSq
- RTD
- 搜索
- SearchB
- SeriesSum
- Sinh
- Skew
- Sln
- Slope
- 小
- SqrtPi
- Standardize
- StDev
- StDev_P
- StDev_S
- StDevP
- StEyx
- Substitute
- 分类汇总
- Sum
- SumIf
- SumIfs
- SumProduct
- SumSq
- SumX2MY2
- SumX2PY2
- SumXMY2
- Syd
- T_Dist
- T_Dist_2t
- T_Dist_RT
- T_Inv
- T_Inv_2T
- T_Test
- Tanh
- TBillEq
- TBillPrice
- TBillYield
- TDist
- 文本
- TInv
- Transpose
- 趋势
- Trim
- TrimMean
- TTest
- USDollar
- Var
- Var_P
- Var_S
- VarP
- Vdb
- VLookup
- 工作日
- WeekNum
- Weibull
- Weibull_Dist
- WorkDay
- WorkDay_Intl
- Xirr
- Xnpv
- YearFrac
- YieldDisc
- YieldMat
- Z_Test
- ZTest
支持和反馈
有关于 Office VBA 或本文档的疑问或反馈? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。
反馈
https://aka.ms/ContentUserFeedback。
即将发布:在整个 2024 年,我们将逐步淘汰作为内容反馈机制的“GitHub 问题”,并将其取代为新的反馈系统。 有关详细信息,请参阅:提交和查看相关反馈