| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complex calculation
Does anyone know how to perform a calculation (multiply/divide/...) between
two complex numbers (x+iy)? It seems that you can get the complex numbers in place using =complex(x,y) but once on screen, e.g. cell A4 and A5, it does not seem possible to perform =A4/A5. I could work it out through by multiplying the complex cojugates and then performing (A4*A5+)(A5*A5) but it seems to make the whole "having a complex function availiable in Excell" pointless. I look forwards to hearing from anyone who knows how to solve the problem |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
complex calculation
Hi Betsie
In Help, use the word 'imaginary' to do a search. You will find IMPRODUCT and IMDIV best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Betsie" wrote in message ... Does anyone know how to perform a calculation (multiply/divide/...) between two complex numbers (x+iy)? It seems that you can get the complex numbers in place using =complex(x,y) but once on screen, e.g. cell A4 and A5, it does not seem possible to perform =A4/A5. I could work it out through by multiplying the complex cojugates and then performing (A4*A5+)(A5*A5) but it seems to make the whole "having a complex function availiable in Excell" pointless. I look forwards to hearing from anyone who knows how to solve the problem |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
complex calculation
Thank you very much :) :)
"Bernard Liengme" wrote: Hi Betsie In Help, use the word 'imaginary' to do a search. You will find IMPRODUCT and IMDIV best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Betsie" wrote in message ... Does anyone know how to perform a calculation (multiply/divide/...) between two complex numbers (x+iy)? It seems that you can get the complex numbers in place using =complex(x,y) but once on screen, e.g. cell A4 and A5, it does not seem possible to perform =A4/A5. I could work it out through by multiplying the complex cojugates and then performing (A4*A5+)(A5*A5) but it seems to make the whole "having a complex function availiable in Excell" pointless. I look forwards to hearing from anyone who knows how to solve the problem |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
| Complex calculation and manipulation in Excel | New Users to Excel | |||
| Complex overtime calculation | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Hybrid Mode
