Excel Function : IMSQRT
Category
Engineering
Description
Returns the square root of a complex number
Microsoft Excel Reference Page
https://support.office.com/en-us/article/IMSQRT-function-e1753f80-ba11-4664-a10e-e17368396b70
Syntax and Description of the IMSQRT Excel Function
I have never come across this syntax before: IMSQRT(number)
. I understand that the SQRT()
function takes the square root, but what does IM
mean?
I have looked up the IMSQRT function in Excel help, but there is no description.
A:
IMSQRT(number)
is a function in the Excel COM add-in Analysis ToolPak:
TheReturns the imaginary coefficient of a complex number in x + yi or x + yj text format.
About IMSQRT Excel Function
IMSQRT returns the inverse square root of a number.