A to Z of Excel Functions: The SECH function

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the SECH function.

The SECH function

The hyperbolic secant function is an old mathematical function.  It has a simple definition as the reciprocal to hyperbolic cosine function:

It has the following chart properties:

This function returns the hyperbolic cosecant of an angle specified in radians.

The SECH function employs the following syntax to operate:

The SECH function has the following arguments:

• number: this is required and represents the angle in radians for which you want the hyperbolic secant.

It should be further noted that:

• the absolute value of number must be less than 2^27
• if the angle is in degrees, either multiply the angle by PI()/180 or use the RADIANS function to covert the angle to radians
• if number is outside its constraints,  SECH returns the #NUM! error value
• if number is a non-numeric value, SECH returns the #VALUE! error value.

Please see my example below: 

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every other business day.