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

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/213294

Hope that helps!

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.

Steve

Steve

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?

Ask Your Question

Weekly Poll

Do you think end-to-end encryption should be banned?

Discuss in The Lounge

Poll History