Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting complex number display
Hello there in never never land.
Can someone help me in formatting complex numbers. How do I get the following simple "complex" function to display as "-1+0i", rather than -1+1.22514845490862E-016i ? function : =+COMPLEX(COS(PI()),SIN(PI())) -- Lewis Engineering Solutions |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting complex number display
Why not just test the size of the imaginary part and if it is really, really
small force the display of 0?: =IMREAL(A1)&IF(ABS(IMAGINARY(A1))<0.0000000001,"+0 i",IMAGINARY(A1)) will display: -1+0i if A1 contains: =+COMPLEX(COS(PI()),SIN(PI())) -- Gary's Student gsnu200702 "Lewis" wrote: Hello there in never never land. Can someone help me in formatting complex numbers. How do I get the following simple "complex" function to display as "-1+0i", rather than -1+1.22514845490862E-016i ? function : =+COMPLEX(COS(PI()),SIN(PI())) -- Lewis Engineering Solutions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when certain number is typed in a cell to display a message | Excel Discussion (Misc queries) | |||
How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
Conditional Number formatting? | Excel Discussion (Misc queries) | |||
Phone Number Formatting | Excel Discussion (Misc queries) | |||
Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) |