Menu
EXCEL IMABS FUNCTION
Excel IMABS Function Introduction
The Imabs function in Excel returns the exact number (modulus) of a real or complex.
Description of Excel IMABS Function
Syntax :
=IMABS( inumber )
Parameters :
- The arguments inumber is a Complex Number.
Step By Step Guide of IMABS Function
Example :
In the following example, the Excel Imabs function is used to calculate the exact number (the modulus) of five distinct complex integers.
The complex number 6+0i is equivalent to the integer 6 in cell B3; the example in cell B5 utilises the Excel Complex Function to generate the complex number 4+i.
Key Points
- #NUM! – This error occurs if the given inumber parameter is not a complex number.
- #VALUE! – Occurs if the inumber parameter supplied 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
WORKDAYS Function
Explore Now
