how can i write complex numbers inside excel cels?

[Guest]

i need to use complex calculation
simply numbers like this one (4∟45°) (polar)
but only that i need to calculate between cels

 

[Bernard Liengme]

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

 

[Guest]

this symbol is angle for polar number
and yes
i'm talking about imaginary numbers also
example fore imaginary (complex) number
8+7i

 

[Rick Rothstein \(MVP - VB\)]

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