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