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

Post a comment