Partager via

IWorksheetFunction Members

  • Article

Include Protected Members
Include Inherited Members

Reserved for internal use.

The IWorksheetFunction type exposes the following members.

Properties

  Name Description
Public property Application
Public property Creator
Public property Parent

Top

Methods

  Name Description
Public method _WSFunction
Public method AccrInt
Public method AccrIntM
Public method Acos
Public method Acosh
Public method Aggregate
Public method AmorDegrc
Public method AmorLinc
Public method And
Public method Asc
Public method Asin
Public method Asinh
Public method Atan2
Public method Atanh
Public method AveDev
Public method Average
Public method AverageIf
Public method AverageIfs
Public method BahtText
Public method BesselI
Public method BesselJ
Public method BesselK
Public method BesselY
Public method Beta_Dist
Public method Beta_Inv
Public method BetaDist
Public method BetaInv
Public method Bin2Dec
Public method Bin2Hex
Public method Bin2Oct
Public method Binom_Dist
Public method Binom_Inv
Public method BinomDist
Public method Ceiling
Public method Ceiling_Precise
Public method ChiDist
Public method ChiInv
Public method ChiSq_Dist
Public method ChiSq_Dist_RT
Public method ChiSq_Inv
Public method ChiSq_Inv_RT
Public method ChiSq_Test
Public method ChiTest
Public method Choose
Public method Clean
Public method Combin
Public method Complex
Public method Confidence
Public method Confidence_Norm
Public method Confidence_T
Public method Convert
Public method Correl
Public method Cosh
Public method Count
Public method CountA
Public method CountBlank
Public method CountIf
Public method CountIfs
Public method CoupDayBs
Public method CoupDays
Public method CoupDaysNc
Public method CoupNcd
Public method CoupNum
Public method CoupPcd
Public method Covar
Public method Covariance_P
Public method Covariance_S
Public method CritBinom
Public method CumIPmt
Public method CumPrinc
Public method DAverage
Public method Days360
Public method Db
Public method Dbcs
Public method DCount
Public method DCountA
Public method Ddb
Public method Dec2Bin
Public method Dec2Hex
Public method Dec2Oct
Public method Degrees
Public method Delta
Public method DevSq
Public method DGet
Public method Disc
Public method DMax
Public method DMin
Public method Dollar
Public method DollarDe
Public method DollarFr
Public method DProduct
Public method DStDev
Public method DStDevP
Public method DSum
Public method Dummy19
Public method Dummy21
Public method Duration
Public method DVar
Public method DVarP
Public method EDate
Public method Effect
Public method EoMonth
Public method Erf
Public method Erf_Precise
Public method ErfC
Public method ErfC_Precise
Public method Even
Public method Expon_Dist
Public method ExponDist
Public method F_Dist
Public method F_Dist_RT
Public method F_Inv
Public method F_Inv_RT
Public method F_Test
Public method Fact
Public method FactDouble
Public method FDist
Public method Find
Public method FindB
Public method FInv
Public method Fisher
Public method FisherInv
Public method Fixed
Public method Floor
Public method Floor_Precise
Public method Forecast
Public method Frequency
Public method FTest
Public method Fv
Public method FVSchedule
Public method Gamma_Dist
Public method Gamma_Inv
Public method GammaDist
Public method GammaInv
Public method GammaLn
Public method GammaLn_Precise
Public method Gcd
Public method GeoMean
Public method GeStep
Public method Growth
Public method HarMean
Public method Hex2Bin
Public method Hex2Dec
Public method Hex2Oct
Public method HLookup
Public method HypGeom_Dist
Public method HypGeomDist
Public method IfError
Public method ImAbs
Public method Imaginary
Public method ImArgument
Public method ImConjugate
Public method ImCos
Public method ImDiv
Public method ImExp
Public method ImLn
Public method ImLog10
Public method ImLog2
Public method ImPower
Public method ImProduct
Public method ImReal
Public method ImSin
Public method ImSqrt
Public method ImSub
Public method ImSum
Public method Index
Public method Intercept
Public method IntRate
Public method Ipmt
Public method Irr
Public method IsErr
Public method IsError
Public method IsEven
Public method IsLogical
Public method IsNA
Public method IsNonText
Public method IsNumber
Public method ISO_Ceiling
Public method IsOdd
Public method Ispmt
Public method IsText
Public method IsThaiDigit
Public method Kurt
Public method Large
Public method Lcm
Public method LinEst
Public method Ln
Public method Log
Public method Log10
Public method LogEst
Public method LogInv
Public method LogNorm_Dist
Public method LogNorm_Inv
Public method LogNormDist
Public method Lookup
Public method Match
Public method Max
Public method MDeterm
Public method MDuration
Public method Median
Public method Min
Public method MInverse
Public method MIrr
Public method MMult
Public method Mode
Public method Mode_Mult
Public method Mode_Sngl
Public method MRound
Public method MultiNomial
Public method NegBinom_Dist
Public method NegBinomDist
Public method NetworkDays
Public method NetworkDays_Intl
Public method Nominal
Public method Norm_Dist
Public method Norm_Inv
Public method Norm_S_Dist
Public method Norm_S_Inv
Public method NormDist
Public method NormInv
Public method NormSDist
Public method NormSInv
Public method NPer
Public method Npv
Public method Oct2Bin
Public method Oct2Dec
Public method Oct2Hex
Public method Odd
Public method OddFPrice
Public method OddFYield
Public method OddLPrice
Public method OddLYield
Public method Or
Public method Pearson
Public method Percentile
Public method Percentile_Exc
Public method Percentile_Inc
Public method PercentRank
Public method PercentRank_Exc
Public method PercentRank_Inc
Public method Permut
Public method Phonetic
Public method Pi
Public method Pmt
Public method Poisson
Public method Poisson_Dist
Public method Power
Public method Ppmt
Public method Price
Public method PriceDisc
Public method PriceMat
Public method Prob
Public method Product
Public method Proper
Public method Pv
Public method Quartile
Public method Quartile_Exc
Public method Quartile_Inc
Public method Quotient
Public method Radians
Public method RandBetween
Public method Rank
Public method Rank_Avg
Public method Rank_Eq
Public method Rate
Public method Received
Public method Replace
Public method ReplaceB
Public method Rept
Public method Roman
Public method Round
Public method RoundBahtDown
Public method RoundBahtUp
Public method RoundDown
Public method RoundUp
Public method RSq
Public method RTD
Public method Search
Public method SearchB
Public method SeriesSum
Public method Sinh
Public method Skew
Public method Sln
Public method Slope
Public method Small
Public method SqrtPi
Public method Standardize
Public method StDev
Public method StDev_P
Public method StDev_S
Public method StDevP
Public method StEyx
Public method Substitute
Public method Subtotal
Public method Sum
Public method SumIf
Public method SumIfs
Public method SumProduct
Public method SumSq
Public method SumX2MY2
Public method SumX2PY2
Public method SumXMY2
Public method Syd
Public method T_Dist
Public method T_Dist_2T
Public method T_Dist_RT
Public method T_Inv
Public method T_Inv_2T
Public method T_Test
Public method Tanh
Public method TBillEq
Public method TBillPrice
Public method TBillYield
Public method TDist
Public method Text
Public method ThaiDayOfWeek
Public method ThaiDigit
Public method ThaiMonthOfYear
Public method ThaiNumSound
Public method ThaiNumString
Public method ThaiStringLength
Public method ThaiYear
Public method TInv
Public method Transpose
Public method Trend
Public method Trim
Public method TrimMean
Public method TTest
Public method USDollar
Public method Var
Public method Var_P
Public method Var_S
Public method VarP
Public method Vdb
Public method VLookup
Public method Weekday
Public method WeekNum
Public method Weibull
Public method Weibull_Dist
Public method WorkDay
Public method WorkDay_Intl
Public method Xirr
Public method Xnpv
Public method YearFrac
Public method YieldDisc
Public method YieldMat
Public method Z_Test
Public method ZTest

Top

See Also

Reference

IWorksheetFunction Interface

Microsoft.Office.Interop.Excel Namespace