“COT”
Used for – “COT” is used find the value of
cotangent of the angle which is written in radians in MS excel and display the
end result achieved.
Syntax – COT(Angle).
Example – Let us continue with the
example of Degree, we have a value in cell B1 0.523599 which comes as result of
formula Radian & value in cell C1 30 which comes as result of formula
Degree and wants excel tells the value of COT of these angles then you can write up the formula as =COT(B1) in cell B2 and
Excel came with answer 1.732051 which is the value equal to cotangent of angle
0.523599 Radian. See example below:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
30
|
=RADIANS(A1)
|
=DEGREES(B1)
|
||||||
2
|
=COT(B1)
|
||||||||
3
|
|||||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
And
result you get as under:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
30
|
0.523599
|
30
|
||||||
2
|
1.732051
|
||||||||
3
|
|||||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
You
can check it yourself by copy the highlighted table and pasting in the first
cell of the spread sheet.
NOTE:-
Here you must note that this formula only reads value in radians as per
default. So please always converts degree angle to radian angle before using
this formula. See the variation you get if you did not convert value into
radians first.
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
30
|
=RADIANS(A1)
|
=DEGREES(B1)
|
||||||
2
|
=COT(B1)
|
=COT(C1)
|
|||||||
3
|
|||||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
And
result you get as under:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
30
|
0.523599
|
30
|
||||||
2
|
1.732051
|
-0.15612
|
|||||||
3
|
|||||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
In
the above example in cell C2 formula directly calculates the tan of C1 i.e.30
what we think MS Excel is calculating cot of 30 degree but the MS excel in
actual calculates as cot of 30 radians which means 1718.873 degrees, which is
not correct in our aspect but it is absolutely right in as per MS excel. So,
for make it sure that MS excel does exactly what we want we have to converts 30
into radians first using RADIANS formula and then should use COT formula.
Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.