TAN

TAN(number)

Returns the tangent of an angle.

number

The angle in radians.

REMARKS

* For an illustrated example refer to the page under Trigonometric Functions.
* This function returns the ratio of the opposite side divided by the adjacent side in a right angled triangle.
* The graph of this function has vertical lines at odd multiples of 90 degrees (-90, 90, 270, 450).
* This function repeats every PI.
* If "number" is not numeric, then #VALUE! is returned. Example 14.
* To convert a number from degress to radians, multiply it by PI/180
* To convert a number from radians to degrees, multiply it by 180/PI.
* The inverse of this function is the ATAN function.
* The tangent of a number is 1/COT.
* You can use the ATAN function to return the arc-tangent. Example 15.
* You can use the COS function to return the cosine of a number.
* You can use the SIN function to return the sine of a number.
* You can use the RADIANS function to convert from degrees to radians.
* You can use the DEGREES function to convert from radians to degrees.
* The equivalent VBA function is VBA.TAN
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=TAN(0) = 0.000
2	=TAN(B2) = 1.000	=PI()/4 = 0.78540
3	=TAN(B3) = 1.63 E16 (very large)	=PI()/2 = 1.57080
4	=TAN(B4) = 0.000	=PI() = 3.14159
5	=TAN(B5) = 5.44 E15 (very large)	=PI()*3/2 = 4.71239
6	=TAN(B6) = 0.000	=PI()*2 = 6.28319
7	=TAN(45*PI()/180) = 1.000
8	=TAN(RADIANS(45)) = 1.000
9	=TAN(ATAN(0.017)) = 0.017
10	=TAN("some text") = #VALUE!

1 - What is the tangent of 0.
2 - What is the tangent of (PI/4)
3 - What is the tangent of (PI/2). This is a very large number.
4 - What is the tangent of (PI)
5 - What is the tangent of (PI*3/2). This is a very large number.
6 - What is the tangent of (PI*2)
7 - What is the tangent of 45 degrees
8 - What is the tangent of 45 degrees
9 - What is the inverse of tangent.
10 - When number is not numeric