IWorksheetFunction Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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)