United States (English) Sign in

Home Products Office 365 Docs Samples Downloads Training How To Support Forums

Office and SharePoint development

Office client development

Office 2013

Excel 2013

Excel 2013 developer reference

Object model

WorksheetFunction Object

Methods

AccrIntM Method

Acos Method

Acosh Method

Acot Method

Acoth Method

Aggregate Method

AmorDegrc Method

AmorLinc Method

And Method

Arabic Method

Asc Method

Asin Method

Asinh Method

Atan2 Method

Atanh Method

AveDev Method

AverageIf Method

AverageIfs Method

BahtText Method

Base Method

Beta_Dist Method

Beta_Inv Method

BetaDist Method

Binom_Dist Method

Binom_Dist_Range Method

Binom_Inv Method

BinomDist Method

Bitand Method

Bitlshift Method

Bitor Method

Bitrshift Method

Bitxor Method

Ceiling_Math Method

Ceiling_Precise Method

ChiInv Method

ChiSq_Dist Method

ChiSq_Dist_RT Method

ChiSq_Inv Method

ChiSq_Inv_RT Method

ChiSq_Test Method

Choose Method

Clean Method

Combin Method

Confidence Method

Confidence_Norm Method

Confidence_T Method

Correl Method

Cosh Method

Cot Method

Coth Method

Count Method

CountA Method

CountBlank Method

CountIfs Method

CoupDayBs Method

CoupDays Method

CoupDaysNc Method

Covar Method

Covariance_P Method

Covariance_S Method

CritBinom Method

Csc Method

Csch Method

CumPrinc Method

DAverage Method

Days Method

Db Method

Dbcs Method

DCount Method

Ddb Method

Delta Method

DevSq Method

DGet Method

Disc Method

DMax Method

DMin Method

Dollar Method

DollarDe Method

DollarFr Method

DProduct Method

DStDev Method

DSum Method

Duration Method

DVar Method

DVarP Method

EDate Method

Effect Method

EncodeUrl Method

Erf Method

Erf_Precise Method

ErfC Method

ErfC_Precise Method

Even Method

Expon_Dist Method

ExponDist Method

F_Dist Method

F_Dist_RT Method

F_Inv Method

F_Inv_RT Method

F_Test Method

Fact Method

FactDouble Method

FDist Method

FilterXML Method

Find Method

FindB Method

FInv Method

Fisher Method

FisherInv Method

Fixed Method

Floor Method

Floor_Math Method

Floor_Precise Method

Forecast Method

Frequency Method

FTest Method

Fv Method

FVSchedule Method

Gamma Method

Gamma_Dist Method

Gamma_Inv Method

GammaDist Method

GammaInv Method

GammaLn_Precise Method

Gauss Method

Gcd Method

GeStep Method

Growth Method

HypGeom_Dist Method

HypGeomDist Method

IfNa Method

ImAbs Method

Imaginary Method

ImArgument Method

ImConjugate Method

ImCos Method

ImCosh Method

ImCot Method

ImCsc Method

ImCsch Method

ImDiv Method

ImExp Method

ImLn Method

ImLog2 Method

ImProduct Method

ImReal Method

ImSec Method

ImSech Method

ImSin Method

ImSinh Method

ImSqrt Method

ImSub Method

ImSum Method

ImTan Method

Index Method

Intercept Method

Ipmt Method

Irr Method

IsErr Method

IsEven Method

IsFormula Method

IsLogical Method

IsNA Method

IsNonText Method

IsNumber Method

ISO_Ceiling Method

IsOdd Method

IsoWeekNum Method

Ispmt Method

IsText Method

Kurt Method

Large Method

Lcm Method

LinEst Method

Ln Method

Log Method

Log10 Method

LogEst Method

LogInv Method

LogNorm_Dist Method

LogNorm_Inv Method

LogNormDist Method

Lookup Method

Match Method

Max Method

MDuration Method

Median Method

Min Method

MInverse Method

MIrr Method

MMult Method

Mode Method

Mode_Mult Method

Mode_Sngl Method

MRound Method

MultiNomial Method

Munit Method

NegBinom_Dist Method

NegBinomDist Method

NetworkDays Method

NetworkDays_Intl Method

Norm_Dist Method

Norm_Inv Method

Norm_S_Dist Method

Norm_S_Inv Method

NormDist Method

NormSDist Method

NormSInv Method

NPer Method

Npv Method

NumberValue Method

Odd Method

OddFPrice Method

OddFYield Method

OddLPrice Method

OddLYield Method

Or Method

PDuration Method

Percentile Method

Percentile_Exc Method

Percentile_Inc Method

PercentRank Method

PercentRank_Exc Method

PercentRank_Inc Method

Permut Method

Permutationa Method

Phi Method

Phonetic Method

Pi Method

Pmt Method

Poisson_Dist Method

Power Method

Ppmt Method

Price Method

PriceDisc Method

PriceMat Method

Prob Method

Proper Method

Pv Method

Quartile Method

Quartile_Exc Method

Quartile_Inc Method

Quotient Method

RandBetween Method

Rank Method

Rank_Avg Method

Rate Method

Received Method

ReplaceB Method

Rept Method

Roman Method

Round Method

RoundDown Method

Rri Method

RSq Method

RTD Method

Search Method

Sec Method

Sech Method

SeriesSum Method

Sinh Method

Skew Method

Skew_p Method

Sln Method

Slope Method

Small Method

SqrtPi Method

Standardize Method

StDev Method

StDevP Method

StEyx Method

Substitute Method

Subtotal Method

Sum Method

SumIf Method

SumIfs Method

SumProduct Method

SumSq Method

SumX2MY2 Method

SumX2PY2 Method

Syd Method

T_Dist Method

T_Dist_2T Method

T_Dist_RT Method

T_Inv Method

T_Inv_2T Method

T_Test Method

Tanh Method

TBillPrice Method

TBillYield Method

TDist Method

Text Method

TInv Method

Transpose Method

Trend Method

Trim Method

TrimMean Method

TTest Method

USDollar Method

Var Method

Var_P Method

Var_S Method

VarP Method

Vdb Method

WebService Method

Weibull_Dist Method

WorkDay_Intl Method

Xirr Method

Xnpv Method

Xor Method

YearFrac Method

YieldDisc Method

YieldMat Method

Z_Test Method

ZTest Method

Minimize

This topic has not yet been rated - Rate this topic

WorksheetFunction.Sech Method (Excel)

Office 2013

Published: July 16, 2012

Returns the hyperbolic secant of an angle.

Version information

Version Added: Excel 2013

expression .Sech(Arg1)

expression A variable that represents a WorksheetFunction Object (Excel) object.

Parameters

Name	Required/Optional	Data type	Description
Arg1	Required	DOUBLE	Angle in radians for which you want the hyperbolic secant.

Return value

DOUBLE

Concepts

WorksheetFunction Object

Other resources

WorksheetFunction Object Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.