“SEC”
Used for – “SEC” is used find the value of
secant of the angle which is written in radians in MS excel and display the end
result achieved.
Syntax – SEC(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 SEC of these angles then you can write up the formula as =SEC(B1) in cell B2 and
Excel came with answer 1.154701 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
|
=SEC(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
|
1.154701
|
||||||||
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
|
=SEC(B1)
|
=SEC(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
|
1.154701
|
6.482921
|
|||||||
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.