ACOT

No Comments

“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.