ACOS function
ACOS works backwards from a cosine to the angle that produced it, returning the angle in radians from 0 to PI. Wrap it in DEGREES if you want the answer in degrees.
Example
Read it as a sentence: find the angle, in radians, whose cosine is 0.5.
A
B
C
D
1
1.047197551
2
3
Syntax
ACOS(number)
-
number(required) - A cosine value between -1 and 1.
Returns: The angle in radians, from 0 to PI.
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 |
|---|---|---|
=ACOS(0.5) | 1.047197551 | Positive |
=ACOS(0) | 1.570796327 | Zero |
=ACOS(-0.5) | 2.094395102 | Negative |
=ACOS("0.5") | 1.047197551 | Text number "0.5" |
=ACOS(TRUE) | 0 | TRUE |
=ACOS({0.1,0.2}) | 1.470628906 | Array constant spills |
=ACOS(2) | #NUM! | Larger value |
=ACOS("abc") | #VALUE! | Non-numeric text |
Watch out for
- Inputs outside -1 to 1 give #NUM!.
- The answer is in radians.
Where it works
- Excel
- ACOS 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 .