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.
Need help with Formulas?
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?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.