Excel tangent function Tan

A, tan function syntax

function function: Returns the tangent value of the given angle.

Grammar

TAN (number)

Parameter introduction

Number is the angle of the tangent, expressed in radians.

Note: If the unit of the parameter is degrees, you can multiply it by PI ()/180 or use the RADIANS function to convert it to radians.

Examples of tan functions

When ①number is the angle

If the number is 45 o'clock, if the direct use of the formula =tan (45) results are: 1.61978

Obviously, not the correct tangent, we should convert the angle of 45 to radians so that we can get the correct result, the following is the correct formula:

=tan (RADIANS (45))

Results return 1

Formula Explanation: The function of the radians function is to convert the angle to radians; If you want to learn how to convert between angles and radians, see the article: http://www.dzwebs.net/3145.html

When ②number is radians

In this case, you can use the formula directly.

When number is 0.785398163397448, the result of the formula =tan (0.785398163397448) returns 1

Knowledge Extension:

If the argument is in degrees, you can multiply it by PI ()/180 or use the RADIANS function to convert it to radians.