“CSC”
Used for – “CSC” is used find the value of
cosecant of the angle which is written in radians in MS excel and display the
end result achieved.
Syntax – CSC(Angle).
Example – Let us continue with the
example of Degree, we have a value in cell B1 0.523599 which comes as result of
formula Radian & value in cell C1 30 which comes as result of formula
Degree and wants excel tells the value of CSC of these angles then you can write up the formula as =CSC(B1) in cell B2 and
Excel came with answer 2 which is the value equal to secant of angle 0.523599
Radian. See example below:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
30
|
=RADIANS(A1)
|
=DEGREES(B1)
|
||||||
2
|
=CSC(B1)
|
||||||||
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
|
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.
NOTE:-
Here you must note that this formula only reads value in radians as per
default. So please always converts degree angle to radian angle before using
this formula. See the variation you get if you did not convert value into
radians first.
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
30
|
=RADIANS(A1)
|
=DEGREES(B1)
|
||||||
2
|
=CSC(B1)
|
=CSC(C1)
|
|||||||
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
|
2
|
-1.01211
|
|||||||
3
|
|||||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
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.