ACOT
Formulas / ACOTCalculate the principal value of the arccotangent of a number.
ACOT(number)
- number - the cotangent of an angle
Examples
=ACOT(B6)The ACOT function above calculates the arccotangent of B6.
=ACOT(-1)The arccotangent of a negative number can be calculated using the ACOT function. For example, the above formula calculates the arccotangent of -1.
=ACOT(-1)*180/PI()Tthe ACOT function can be used in combination with the PI. such as in the formula above which calculates the arccotangent of -1 multiplied by 180/PI() to get the answer in degrees.
=DEGREES(ACOT(-1))The DEGREES function can also be used to get the result of a calculation in degrees like the forumula above which calculates the arccotangent of -1 and returns the answer in degrees.
Summary
The ACOT function calculates the principal value of the inverse cotangent (arccotangent) of a real number. It returns the angle in radians and #VALUE! if the argument is not a real number.
- The ACOT function takes a real number as its argument that is the cotangent of an angle.
- The angle must be real and the result is returned in radians.
- The ACOT function returns #VALUE! if the argument is not a number.
Frequently Asked Questions
What is the purpose of the ACOT function?
What does the ACOT function take as an argument?
What does the ACOT function return?
How can I convert the output of the ACOT function to degrees?
What happens if the argument of the ACOT function is not a numeric value?
