Exceljet

Quick, clean, and to the point

Excel TAN Function

Excel TAN function
Summary 

The Excel TAN function returns the tangent of angle given in radians. To supply an angle to TAN in degrees, multiply the angle by PI()/180 or use the RADIANS function to convert to radians.

Purpose 
Get the tangent of an angle
Return value 
The tangent value.
Syntax 
=TAN (number)
Arguments 
  • number - The angle in radians for which you want the tangent.
Usage notes 

The TAN function expects radians. To supply an angle to TAN in degrees, multiply the angle by PI()/180 or use the RADIANS function to convert to radians. For example, to get the TAN of 60 degrees, you can use either formula below:

=TAN(45*PI()/180)
=TAN(RADIANS(45))
Related functions 
Excel SIN function
Excel SIN Function

The Excel SIN function returns the sine of angle given in radians. To supply an angle to SIN in degrees, multiply the angle by PI()/180 or use the RADIANS function to convert to radians.

Excel COS function
Excel COS Function

The Excel COS function returns the cosine of an angle given in radians. To supply an angle to COS in degrees, multiply the angle by PI()/180 or use the RADIANS function to convert to radians.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formula Examples, thoughtfully explained.