Menu
EXCEL IMSUM FUNCTION
Excel IMSUM Function Introduction
The Imsum function in Excel computes the sum of two or more complicated values.
Description of Excel IMSUM Function
Syntax :
=IMSUM( inumber1, inumber2, … )
Parameters :
The following parameters are :
- The innumer arguments range from 2 to 255 Complex Numbers.
Step By Step Guide of IMSUM Function
Example :
The inumber inputs to the Excel Imsum function can be either: Simple numbers; Complex numbers enclosed in quote marks – for example, “5+3i”; References to cells holding complex numbers or numeric values; Values provided by other Excel functions or formulae The complex number 2+0i is identical to the integer 2 in cell B2; the example in cell B3 utilises the Excel Complex Function to generate the complex numbers 5+2i and i.
Key Points
- #NUM! – This error occurs if any of the specified inumber parameters are not complex numbers.
- #VALUE! – Occurs if any of the inumber arguments given are logical values.
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
