IWorksheetFunction Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Reserved for internal use.

public interface class IWorksheetFunction

[System.Runtime.InteropServices.Guid("00020845-0001-0000-C000-000000000046")]
public interface IWorksheetFunction

Public Interface IWorksheetFunction

Attributes: GuidAttribute

Properties

Application
Creator
Parent

Methods

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

Applies to

Condividi tramite

IWorksheetFunction Interface

Definition

Properties

Methods

Applies to

Commenti e suggerimenti

Risorse aggiuntive