“TAN”
Used for – “TAN” is used find the value of tangent of the angle which is written in radians in MS excel and display the end
result achieved.
Syntax – TAN(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 TAN of these angles then you can write up the formula as =TAN(B1) in cell B2 and Excel
came with answer 0.57735 which is the value equal to tan of angle 0.523599 Radian.
See example below:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
30
|
=RADIANS(A1)
|
=DEGREES(B1)
|
||||||
2
|
=TAN(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
|
0.57735
|
||||||||
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
|
=TAN(B1)
|
=TAN(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
|
0.57735
|
-6.40533
|
|||||||
3
|
|||||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
In
the above example in cell C2 formula directly calculates the tan of C1 i.e.30
what we think MS Excel is calculating tan of 30 degree but the MS excel in actual
calculates as tan of 30 radians which means 1718.873 degrees, which is not
correct in our aspect but it is absolutely right in as per MS excel. So, for
make it sure that MS excel does exactly what we want we have to converts 30
into radians first using RADIANS formula and then should use TAN 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.