Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display absolute value of complex number
How do I change the format of an Excel cell containing a complex number to
just display the absolute value of the complex number, or failing that, reduce the number of digits displayed ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display absolute value of complex number
How do I change the format of an Excel cell containing a complex number to
just display the absolute value of the complex number, I don't believe Excel's formatting can do this alone. I think you would need an additional function. If A1 has the text 3+4i then =IMABS(A1) retuns 5 -- HTH :) Dana DeLouis Windows XP & Office 2003 "GraemeD" wrote in message ... How do I change the format of an Excel cell containing a complex number to just display the absolute value of the complex number, or failing that, reduce the number of digits displayed ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display number of day of month depending on the year | Excel Discussion (Misc queries) | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
Formatting: Display a minus sign before a number | Excel Discussion (Misc queries) | |||
How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)? | Excel Discussion (Misc queries) | |||
How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) |