“ACOT”
Used for – “ACOT” is used find the value
of arccotangent in radians of the angle which is written in numbers in MS excel
and display the end result achieved.
Syntax – ACOT(Number).
Example – Let us continue with the
example of COT, we have a value in cell B2 1.732051 & value in cell C2 -0.15612
which comes as result of formula COT and wants excel tells the value of arctangent
of these numbers then you can write up the
formula as =ACOT(B2) in cell B3 & =ACOT(C2) in cell C3 and Excel came with
answer 0.523599 & 30 respectively which is the value equal to arccotangent
of number 1.732051 & -0.15612. See example below:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
30
|
=RADIANS(A1)
|
=DEGREES(B1)
|
||||||
2
|
=COT(B1)
|
=COT(C1)
|
|||||||
3
|
=ACOT(B2)
|
=ACOT(C2)
|
|||||||
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
|
0.523599
|
30
|
|||||||
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 gives answer only in radians as per
default. So please always converts the answer using DEGREE 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.