Menu
EXCEL IMTAN FUNCTION
Excel IMTAN Function Introduction
The Imtan function in Excel returns the tangent of a complex value.
Description of Excel IMTAN Function
Syntax :
=IMTAN( inumber )
Parameters :
The following parameters are :
- The complex number whose tangent you wish to compute is specified by the inumber parameter.
Step By Step Guide of IMTAN Function
Example :
The Imtan function in Excel is used to compute the tangent of four separate complex integers. In cell B1, the real number 0.5 matches the complex number 0.5+0i; in cell B4, the Excel Complex Function is utilised to generate the complex number 1-i.
Key Points
- #NUM! – This error occurs if the given inumber parameter is not a complex number.
- #VALUE! – Occurs if the inumber argument supplied is a logical value.
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
