“DEGREES”
Used for – “DEGREES” is used tell MS excel
that a excel has to take the value of angle in Degree which you have written in
Radians or come out from any calculation as Radians and display the end result
achieved. Or in simple words this formula is used to conversion from Radians to
Degrees for an angle or a value.
Syntax – DEGREES(Angle).
Example – Let us continue with the
example of Radians, we have a value in cell B1 0.523599 which comes as result
of formula Radian and wants excel reads it as angle but value of this will be
equal to the angle of 0.523599 Radians then you
can write up the formula as =DEGREE(B1) in cell C1 and Excel came with answer 30
which is the value equal to 0.523599 Radian of angle in radian. See example
below:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
30
|
=RADIANS(A1)
|
=DEGREES(B1)
|
||||||
2
|
|||||||||
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
|
|||||||||
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.
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.