How to use ACOS function in excel

blog img

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

Your email address will not be published. All fields are required.

Related post

  1. How to use LOWER Function in Excel

    Excel Lower Function…

  1. How to use AVERAGE Function in Excel.

    This function calculates…

  1. How to use ADDRESS Function in Excel

    The ADDRESS function…

  1. How to use ACOSH function in excel

    The ACOSH function…

  1. How to use ACOT function in excel

    The Excel ACOT…