ACOSH function
ACOSH returns the inverse hyperbolic cosine of a number, reversing COSH. It is mostly seen in engineering and statistics formulas, and anything below 1 gives a #NUM! error.
Example
Read it as a sentence: find the inverse hyperbolic cosine of the number in E1, which is 5.
Excel shows 2.29243167
E
1
5
Data
Syntax
ACOSH(number)
-
number(required) - A number of 1 or more.
Returns: The inverse hyperbolic cosine of the number.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ACOSH(2) | 1.316957897 | Larger value |
=ACOSH(TRUE) | 0 | TRUE |
=ACOSH(1) | 0 | Domain: 1 |
=ACOSH(Data!E1) | 2.29243167 | Text-number cell |
=ACOSH(Data!A1:A3) | 0 | Range spills |
=ACOSH(0.5) | #NUM! | Positive |
=ACOSH(0) | #NUM! | Zero |
=ACOSH(-0.5) | #NUM! | Negative |
The Data sheet these formulas read
A cell that starts with = holds that formula.
A
E
1
1
5
2
2
abc
3
3
TRUE
Data
Watch out for
- Anything below 1 returns #NUM!.
Where it works
- Excel
- ACOSH is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .