IMTAN

IMTAN(inumber)

Returns the tangent ratio of a complex number.

inumberThe complex number.

REMARKS
* If "inumber" is not in the form x + yi or x + yj, then #NUM! is returned.
* If "inumber" is not text, then #VALUE! is returned.
* You can use the TAN function to return the tangent ratio of an angle.
* You can use the IMCOS function to return the cosine ratio of a complex number.
* You can use the IMSIN function to return the sine ratio of a complex number.
* You can use the COMPLEX function to convert real and imaginary coefficients into a complex number.
* You can use the TEXT function to return the number as a formatted text string.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=IMTAN("1+i") = 0.271752585319512+1.08392332733869i
2=IMTAN("i") = 0.761594155955765i
3=TEXT(IMTAN("i"), "0.000") = 0.761594155955765i
4=IMTAN("text") = #NUM!


© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top