Better Sheets

How to Use ACOTH() in Google Sheets

Description

Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..

How To Actually Use ACOTH() in Sheets

ACOTH(value)

Try ACOTH yourself

In cells A1:A10, enter various values outside the range of -1 to 1. Use the ACOTH formula to calculate the inverse hyperbolic cotangent of each value in the corresponding B1:B10 cells.

Your formula

Hints (2)

Locale Separator ,

Official Docs

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 BetterSheets.co/formulas

Transcript-matched member videos for ACOTH(). Click through to watch.

Browse more tutorials

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Intermediate

CONCATENATE() ROUND()

What is this Ampersand Doing in Google Sheets?

What is "&" doing in this formula? MONTH(A1&1)
Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.

CONCAT() DATE() MONTH() VALUE()

Unlock these tutorials

Learn more about the ACOTH() formula:

Generate a ACOTH() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses ACOTH(). 2 free AI generations, no signup. Members get unlimited use.

Generate a ACOTH() formula

How to Use ACOTH() in Google Sheets

Try ACOTH yourself

More related tutorials

Calculate ROAS in Google Sheets

What is this Ampersand Doing in Google Sheets?