# EXCEL complex number functions

Ausu P4T
April 3, 2008 at 11:16:17
Specs: XP SP2, Pentium 4/512MB
 EXCEL has several functions to support complex number math: IMARGUMENT, IMABS, IMPRODUCT, etc.The results typically have about 15 decimal places and may or may not be in scientific notation.Is there a way to format the numbers in the results? To specify the number of decimal places? Scientific notation or not?Thanks.Steve

See More: EXCEL complex number functions

#1
April 3, 2008 at 12:37:57
 This example will give you 3 decimal places for each part of the result of an IMSIN() calculation.=COMPLEX(ROUND(IMREAL(IMSIN("3+4i")),3),ROUND(IMAGINARY(IMSIN("3+4i")),3),RIGHT(IMSIN("3+4i"),1))Obviously, you don't need to imbed the IMSIN() in the formula, but it keeps everything in the same cell if you do.Or you can create a User Defined Function (UDF) in VBA:http://support.microsoft.com/kb/213294Hope that helps!

Report •

#2
April 12, 2008 at 19:40:26
 Thanks for the tip about the ROUND function.Is there a way to use it on the complex numbers which come of functions such as IMSQRT or IMPRODUCT which themselves have other imaginary functions embedded in them?Or another way to format such results?Thanks.SteveSteve

Report •

#3
April 12, 2008 at 19:44:21
 I'm not sure what you are asking.Do you have an example of something that's giving you a problem...along with the way you want it to look?

Report •

Related Solutions