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




"agathon" wrote in message
...
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.