How to use complex no. functions that have cell references?

[Guest]

example: imsqrt. The only example in Help uses literal number args. I
want the args to be cell references. When I use literal cell references I
get NUM error.

 

[JE McGimpsey]

This works for me:

D2: = 2+3i

D4: =IMSQRT(D2)

Make sure that the "i" is lower case (you can use

D4: =IMSQRT(LOWER(D2))

to make sure.

 

[Bernie Deitrick]

You can also build up the argument string. For example with
2
in cell A1, and
'-3i
in cell A2, you can use

=IMSQRT(A1&A2)

Note that the imaginary part needs to be entered with a single quote, then
the sign, then the multiplier and then the lower case i.

So if you wanted imsqrt(3+3i), enter 3 into cell A1, and '+3i into A2.

HTH,
Bernie
MS Excel MVP