Author: Oscar Cronquist Article last updated on November 17, 2022

How to use the IMSQRT function

The IMSQRT function calculates the square root of a complex number in x + yi or x + yj text format.

The letter j is used in electrical engineering to distinguish between the imaginary value and the electric current.

C = x + yi

IMSQRT(C) = (x + yi)^0.5 = r^0.5 cos (θ/2) + ir^0.5 sin (θ/2)

θ = tan-1 (x/y)

r = (x2 + y2)^0.5

1. IMSQRT Function Syntax

IMSQRT(inumber)

Back to top

2. IMSQRT Function Arguments

inumber Required. A complex number in x+yi or x+yj text format.

Back to top

3. IMSQRT function example

How to use the IMSQRT function

The image above demonstrates a formula in cell D3 that calculates the square root of a complex number specified in cell B3.

Formula in cell D3:

=IMSQRT(B3)

3.1 Explaining formula

Step 1 - Populate arguments

IMSQRT(inumber)

becomes

IMSQRT(B3)

Step 2 - Evaluate the IMSQRT function

IMSQRT(B3)

becomes

IMSQRT("1+2i")

and returns

-1.27201964951407+0.786151377757423i

Back to top