TAN

No Comments

“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.