Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i write complex numbers inside excel cels?
i need to use complex calculation
simply numbers like this one (4ˆŸ45°) (polar) but only that i need to calculate between cels |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i write complex numbers inside excel cels?
Please tell us more.
What is the symbol between 4 and 45? What do you want to do with this? Are you using the word 'complex' in the same sense as 'imaginary' numbers? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "STINGER" wrote in message ... i need to use complex calculation simply numbers like this one (4?45°) (polar) but only that i need to calculate between cels |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i write complex numbers inside excel cels?
this symbol is angle for polar number
and yes i'm talking about imaginary numbers also example fore imaginary (complex) number 8+7i "Bernard Liengme" wrote: Please tell us more. What is the symbol between 4 and 45? What do you want to do with this? Are you using the word 'complex' in the same sense as 'imaginary' numbers? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "STINGER" wrote in message ... i need to use complex calculation simply numbers like this one (4?45°) (polar) but only that i need to calculate between cels |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i write complex numbers inside excel cels?
I'm not sure if this is what you are looking for or not... you can convert
polar number to an imaginary number this way... =LEFT(A1,FIND("ˆŸ",A1)-1)*COS(MID(A1,FIND("ˆŸ",A1)+1,255)*PI()/180)&"+"&LEFT(A1,FIND("ˆŸ",A1)-1)*SIN(MID(A1,FIND("ˆŸ",A1)+1,255)*PI()/180)&LOWER("I") where I'm assuming A1 has the polar number you posted. Once converted, you can use the various Engineering formulas whose names start with IM to manipulate the complex number that results. If you then need to convert that imaginary number back into polar form, you can use this formula... =IMABS(B1)&"ˆŸ"&IMARGUMENT(B1)*180/PI()&"°" Note: In the first formula above, I have assumed your cell entry has the "ˆŸ" symbol embedded between the numbers and that it has the "°" symbol at the end. If this is not the case, the formulas will have to be modified. Rick "STINGER" wrote in message ... this symbol is angle for polar number and yes i'm talking about imaginary numbers also example fore imaginary (complex) number 8+7i "Bernard Liengme" wrote: Please tell us more. What is the symbol between 4 and 45? What do you want to do with this? Are you using the word 'complex' in the same sense as 'imaginary' numbers? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "STINGER" wrote in message ... i need to use complex calculation simply numbers like this one (4?45°) (polar) but only that i need to calculate between cels |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import complex numbers to excel | Excel Worksheet Functions | |||
How do I set up Excel to handle complex (& imaginary) numbers? | Excel Worksheet Functions | |||
Does Office 2000 Excel support complex numbers at all? | Setting up and Configuration of Excel | |||
Autofill cels based on two dates in adjacent cels | Excel Worksheet Functions | |||
how to get word amounts from numbers in cels | Excel Discussion (Misc queries) |