How to use SECH Google Sheets formula?

The syntax for the SECH formula is =SECH(value), it has 1 required parameter.

Why is SECH Google Sheets formula not working?

One common reason the SECH formula may not be working is due to missing argument. Make sure to provide a value as an argument to the SECH function.

SECH

The SECH function returns the hyperbolic secant of an angle provided in radians. It is the reciprocal of the hyperbolic cosine (COSH) of an angle. The function is commonly used in trigonometry and calculus.

How to use SECH formula?
Examples of using SECH formula
SECH formula not working?
Similar formulas to SECH

Usage

Use the SECH formula with the syntax shown below, it has 1 required parameter:

=SECH(value)

Parameters:

value (required):
The angle in radians for which to calculate the hyperbolic secant.

Examples

Here are a few example use cases that explain how to use the SECH formula in Google Sheets.

Calculate the hyperbolic secant of an angle

SECH can be used to calculate the hyperbolic secant of an angle in radians, which can be useful in trigonometry and calculus.

Calculate the inverse hyperbolic secant of a value

The inverse hyperbolic secant of a value can be calculated using the formula =LN((1+SQRT(1-value^2))/value).

Calculate the derivative of a function

SECH can be used to calculate the derivative of a function in calculus.

Common Mistakes

SECH not working? Here are some common mistakes people make when using the SECH Google Sheets Formula:

Missing argument

Make sure to provide a value as an argument to the SECH function.

Incorrect argument type

SECH expects a numeric value as its argument. Make sure to provide a numeric value.

The following functions are similar to SECH or are often used with it in a formula:

SINH
The SINH function returns the hyperbolic sine of any real number. The hyperbolic sine is a mathematical function that describes the shape of a hanging cable supported at its ends and acted upon by a uniform gravitational force. In Google Sheets, it is most commonly used in mathematical and statistical formulas.
COSH
The COSH function returns the hyperbolic cosine of a given value. The hyperbolic cosine is defined as (e^x + e^-x) / 2, where x is the given value. This function is most commonly used in mathematical calculations and modeling.
TANH
The TANH function returns the hyperbolic tangent of a value. It is commonly used in mathematical modeling, such as in statistics, physics, and engineering.
ACOSH
The ACOSH function returns the inverse hyperbolic cosine of a number. In other words, it calculates the value whose hyperbolic cosine is the specified number. This function is useful for solving mathematical problems involving hyperbolic functions.
ATANH
The ATANH function returns the inverse hyperbolic tangent of a value. It is commonly used in mathematical calculations involving hyperbolic functions.

Learn More

You can learn more about the SECH Google Sheets function on Google Support.