Menu
EXCEL IMSQRT FUNCTION
Excel IMSQRT Function Introduction
The Imsqrt function in Excel returns the cube root of a complex value.
Description of Excel IMSQRT Function
Syntax :
=IMSQRT( inumber )
Parameters :
The complex integer whose square root you require is specified in the inumber parameter.
Step By Step Guide of IMSQRT Function
Example :
The Excel Imsqrt function is used in the worksheets below to calculate the square root of five distinct complex integers.
Key Points
- #NUM! – This error occurs if the given inumber parameter is not a complex number.
- #VALUE! – Occurs if the inumber parameter given is a logical value.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORK DAYS Function
Explore Now
