Menu
EXCEL TAN FUNCTION
Excel TAN Function Introduction
The TAN function in Excel computes the tangent of a given angle.
Description of Excel TAN Function
Syntax :
=TAN( number )
Parameters :
- The angle in radians that you wish to compute the tangent of is specified in the number parameter.
Step By Step Guide of TAN Function
Example :
The spreadsheet below illustrates the Excel Tan Function, which is used to determine the tangent of four distinct angles.
In cell A3, the Excel Pi function is used to provide the number 4; in cell A4, the Excel Radians function is used to convert the angle of -45 degrees into radians before passing it to the Tan function.
Key Points
- If your parameter is in degrees, multiply it by PI()/180 or translate it to radians using the RADIANS function.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
