## Worksheet Function Methods

The methods of the WorksheetFunction object are actually individual Excel functions that do not have VBA equivalents. The Excel functions listed here constitute the methods of the WorksheetFunction object. You can explore these functions in detail by going to Excel's Help and entering the keywords "List of Functions" in the Search box.

 □ AccrInt □ AveDev □ Bin2Hex □ AccrIntM □ Average □ Bin2Oct □ Acos □ AverageIf □ BinomDist □ Acosh □ AverageIfs □ Ceiling □ AmorDegrc □ BahtText □ ChiDist □ AmorLinc □ Bessell □ ChiInv □ And □ BesselJ □ ChiTest □ Asc □ BesselK □ Choose □ Asin □ BesselY □ Clean □ Asinh □ BetaDist □ Combin □ Atan2 □ Betalnv □ Complex □ Atanh □ Bin2Dec □ Confidence
 □ Convert □ Disc □ FTest □ Correl □ DMax □ Fv □ Cosh □ DMin □ FVSchedule □ Count □ Dollar □ GammaDist □ CountA □ DollarDe □ Gammalnv □ CountBlank □ DollarFr □ GammaLn □ CountIf □ DProduct □ Gcd □ Countlfs □ DStDev □ GeoMean □ CoupDayBs □ DStDevP □ GeStep □ CoupDays □ DSum □ Growth □ CoupDaysNc □ Duration □ HarMean □ CoupNcd □ DVar □ Hex2Bin □ CoupNum □ DVarP □ Hex2Dec □ CoupPcd □ EDate □ Hex2Oct □ Covar □ Effect □ HLookup □ CritBinom □ EoMonth □ HypGeomDist □ CumIPmt □ Erf □ IfError □ CumPrinc □ ErfC □ ImAbs □ DAverage □ Even □ Imaginary □ Days3 60 □ ExponDist □ ImArgument □ Db □ Fact □ ImConjugate □ Dbcs □ FactDouble □ ImCos □ DCount □ FDist □ ImDiv □ DCountA □ Find □ ImExp □ Ddb □ FindB □ ImLn □ Dec2Bin □ FInv □ ImLoglO □ Dec2Hex □ Fisher □ ImLog2 □ Dec2Oct □ Fisherlnv □ ImPower □ Degrees □ Fixed □ ImProduct □ Delta □ Floor □ ImReal □ DevSq □ Forecast □ ImSin □ DGet □ Frequency □ ImSqrt
 □ ImSub □ Median □ Pmt □ ImSum □ Min □ Poisson □ Index □ MInverse □ Power □ Intercept □ MIrr □ Ppmt □ IntRate □ MMult □ Price □ Ipmt □ Mode □ PriceDisc □ Irr □ MRound □ PriceMat □ IsErr □ MultiNomial □ Prob □ IsError □ NegBinomDist □ Product □ IsEven □ NetworkDays □ Proper □ IsLogical □ Nominal □ Pv □ IsNA □ NormDist □ Quartile □ IsNonText □ NormInv □ Quotient □ IsNumber □ NormSDist □ Radians □ IsOdd □ NormSInv □ RandBetween □ Ispmt □ NPer □ Rank □ IsText □ Npv □ Rate □ Kurt □ Oct2Bin □ Received □ Large □ Oct2Dec □ Replace □ Lcm □ Oct2Hex □ ReplaceB □ LinEst □ Odd □ Rept □ Ln □ OddFPrice □ Roman □ Log □ OddFYield □ Round □ Log10 □ OddLPrice □ RoundDown □ LogEst □ OddLYield □ RoundUp □ LogInv □ Or □ RSq □ LogNormDist □ Pearson □ RTD □ Lookup □ Percentile □ Search □ Match □ PercentRank □ SearchB □ Max □ Permut □ SeriesSum □ MDeterm □ Phonetic □ Sinh □ MDuration □ Pi □ Skew
 □ Sln □ SumX2PY2 □ Var □ Slope □ SumXMY2 □ VarP □ Small □ Syd □ Vdb □ SqrtPi □ Tanh □ VLookup □ Standardize □ TBillEq □ Weekday □ StDev □ TBillPrice □ WeekNum □ StDevP □ TBillYield □ Weibull □ StEyx □ TDist □ WorkDay □ Substitute □ Text □ Xirr □ Subtotal □ TInv □ Xnpv □ Sum □ Transpose □ YearFrac □ SumIf □ Trend □ YieldDisc □ SumIfs □ Trim □ YieldMat □ SumProduct □ TrimMean □ ZTest □ SumSq □ TTest □ SumX2MY2 □ USDollar
0 0