## How to convert complex numbers to polar form?

Formula in cell D4:

Complex numbers are usually presented in this form

z = x + yi

or

z = x + yj

However, complex numbers can also be represented in polar form:

z = r*(cos Î¸ + isin Î¸)

In other words, theta Î¸ in the polar form is calculated using the IMARGUMENT based on complex numbers.

Pythagorean Theorem

r^{2Â }= x^{2}Â + y^{2}

To calculate the absolute value we can use this formula:

r = âˆš(x^{2}+y^{2})

Excel has a function that does this for you, the IMABS function calculates the absolute value based on complex numbers.

### Explaining formula

#### Step 1 - Calculate theta Î¸

The IMARGUMENT function calculates theta Î¸ which is an angle displayed in radians based on complex numbers in rectangular form.

Function syntax: IMARGUMENT(inumber)

IMARGUMENT(C4)

becomes

IMARGUMENT("12+9i")

and returns

0.643501108793284

#### Step 2 - Calculate the absolute value

The IMABS function calculates the absolute value (modulus) of a complex number in x + yi or x + yj text format.

Function syntax: IMABS(inumber)

IMABS(C4)

becomes

IMABS("12+9i")

and returns

15

#### Step 3 - Join calculations with text

The ampersand character lets you concatenate values in an Excel Formula.

IMABS(C4)&"(cos "&IMARGUMENT(C4)&" + isin "&IMARGUMENT(C4)&")"

#### Step 4 - Evaluate the formula

IMABS(C4)&"(cos "&IMARGUMENT(C4)&" + isin "&IMARGUMENT(C4)&")"

becomes

15&"(cos "&0.643501108793284&" + isin "&0.643501108793284&")"

and returns

15(cos 0.643501108793284 + isin 0.643501108793284)

More than 1300 Excel formulas### Excel categories

### Leave a Reply

### How to comment

**How to add a formula to your comment**

<code>Insert your formula here.</code>

**Convert less than and larger than signs**

Use html character entities instead of less than and larger than signs.

< becomes < and > becomes >

**How to add VBA code to your comment**

[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org or imgur

Paste image link to your comment.

**Contact Oscar**

You can contact me through this contact form