Excel SECH Function

What is SECH Function in Excel?

The SECH function is one of the math functions of Excel.

It Returns the hyperbolic secant of an angle.

We can find this function in Math & trig category of insert function Tab.

How to use SECH function in excel

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on the fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

 insert function tab in excel

4. Select math and trig category

5. Select SECH function

6. Then select ok

excel SECH function

7. In the function arguments Tab you will see SECH function

8. Number is the angle in radians for which you want the hyperbolic secant

9. You will see results in the formula result section

How to use SECH function in excel

Examples of SECH function in Excel

Example 1:

How to use SECH function in excel

You can see examples of SECH function below:

Examples of SECH function in Excel
sech(1) ----->>>>answer is  0.648

sech(0.5) ----->>>>answer is  0.886

sech(0.1) ----->>>>answer is  0.995

sech(-0.5) ----->>>>answer is  0.886

sech(-0.1) ----->>>>answer is  0.995

What is the purpose of SECH function?

It Returns the hyperbolic secant of an angle.

What is the Return value of SECH function?

It returns a number.

How many arguments does SECH function have?

This function has just 1 Argument.

The argument of SECH function is number.

Number is the angle in radians for which you want the hyperbolic secant.

The argument of SECH function is required and not optional.

SECH(number) = number

Which version of excel supports SECH function?

This function is available for all excel versions (2003-2019)

Errors in SECH function

SECH related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *