Formulas > =SECH()

How To Use SECH() Function in Google Sheets


The SECH function returns the hyperbolic secant of an angle.

Common questions about the SECH formula include:
• What does SECH stand for?
• What does the SECH formula do?
• How do I enter the formula?
• How is the SECH formula different from other formulas?

The SECH formula in Google Sheets can be used to calculate the standard deviation of values in the selected data range, ignoring text and empty cells. It is most commonly used to measure variability in a dataset.

The SECH formula is sometimes mistyped as "SEC" or "STDev." Other common misspellings are SEHC, SCHE, SICH.

The SECH formula shouldn't be used to calculate the average of a data set, or to measure the central tendency of a data set. It is also not suitable for measuring the correlation between two datasets.

Common pitfalls when using the SECH formula include forgetting to ignore empty cells or directly entering values without using a data range. Additionally, the order of the cells in the selected range can affect the output of the formula.

Common mistakes when using the SECH Formula can include not understanding the formula or forgetting to select the correct data range.

Common misconceptions people might have with the SECH Formula include believing that the standard deviation measures the central tendency of a dataset, that it averages out the dataset, or that it can measure the correlation between two datasets.

How To Actually Use SECH() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the SECH() formula:


🤔 ABOUT THIS Lesson 👇 SECH FUNCTION IN EXCEL BY EXCEL IN A MINUTE. Welcome to Excel in a Minute! In this video, we are going to discuss why that happens and how to use SECH FUNCTION IN EXCEL BY EXCEL IN A MINUTE

Generate a SECH() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.