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