EXCEL IMSUB FUNCTION

The Imsub function in Excel computes the difference between two complex integers (i.e. subtracts one complex number from another).

Syntax :

=IMSUB( inumber1inumber2 )

Parameters :

The following parameters are :

  • You wish to subtract inumber2 from inumber1, and the inumber parameters are Complex Numbers.
    The inumber parameters to the Excel Imsub function can be either:
  • Numbers that are simple;
  • Complex numbers surrounded by quote marks, such as “5+3i”;
  • Cells holding complex numbers or numeric values are referenced.
  • Excel values returned by other functions or formulae.

Step By Step Guide of IMSUB Function

Example :

Excel values returned by other functions or formulae The complex number 6+0i is identical to the integer 6 in cell B2; the example in cell B3 utilises the Excel Complex Function to generate the complex numbers 5+2i and i.

  • #NUM! – This error occurs if one or both of the supplied inumber arguments are not complex numbers.
  • #VALUE! – This error occurs when one or both of the supplied inumber arguments are logical values.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now