COT(number)

Returns the cotangent of a number.


numberThe number you want the cotangent of.

Remarks

* Added in Excel 2013.
* The "number" is the angle in radians.
* If "number" is not numeric, then #VALUE is returned.
* If "number" is zero, then #DIV/0! is returned.
* If "number" < -2 E10, then #NUM is returned.
* If "number" > 2 E10, then #NUM is returned.
* If your argument is in degrees, multiply it by PI/180 to convert it to radians.
* You can use the DEGREES function to convert from radians to degrees.
* The inverse of this function is the ACOT function. Example 8.
* For a working example refer to the Quant > Trigonometric Functions page.
* For the Microsoft documentation refer to support.office.com

 A
1=COT(ACOT(0.014)) = 0.014
2=COT(-PI()/4) = -1.000
3=COT(RADIANS(45)) = 1.000
4=COT("some text") = #VALUE!
5=COT(0) = #DIV/0!
6=COT(2E+29) = #NUM!

1 - What is the cotangent of 0 radians.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top