How to use ACOS function in excel

Posted on: April 6, 2021 in Excel Functions ,

Inverse cosine excel

The ACOS function returns several inverse cosines of a number.
The returned angle is given in radians in the range 0 (zero) to pi.
This function is an inverse of COS and it only expects input from the range of -1 to 1. It gives a #NUM error when input is given outside the range of -1 to 1. The arccosine is the angle whose cosine is number.

Return value

Returns the arccosine, or inverse cosine, of a number.

Angle in radians.

Syntax


=ACOS(number)

Arguments:

The ACOS function syntax has the following arguments:

Number Required. The cosine of the angle you want and must be from -1 to 1.

It gives a #NUM error when input is given outside the range of -1 to 1. The arccosine is the angle whose cosine is number.

Note: If you want to convert the result from radians to degrees, multiply it by 180/PI() or use the DEGREES function

Examples

Formula	Description	Result
=ACOS(-0.9)	Arc cosine of -0.9 in radians, 2*pi/3	2.690565842
=ACOS(-0.5)*180/PI()	Arc cosine of -0.5 in degrees	120
=ACOS(D5)	Arc cosine of D5 cell value in degrees	1.875488981

Share your thoughts Cancel reply

How to Use XLOOKUP with Multiple Criteria in Excel
While Excel’s XLOOKUP function does not natively support multiple criteria…

How to Use XLOOKUP in Excel
XLOOKUP is a versatile function in Excel used for performing…

How to use LOWER Function in Excel
Excel Lower Function Converts all uppercase letters in a text…

How to use AVERAGE Function in Excel.
This function calculates the average from a list of numbers.…

How to use ADDRESS Function in Excel
The ADDRESS function to obtain the address of a cell…