March 1, 2024

How to use IMSUB Function in Excel

The IMSUB function returns the difference of two complex numbers in x + yi or x + yj text format. When subtracting complex numbers, the real and imaginary coefficients are subtracted separately i.e., the equation to subtract complex number c+di from complex number a + bi is: (a + bi) – (c + di) = (a – c) + (b – d)i

Syntax:= IMSUB (inumber1, inumber2)

The IMSUB function syntax has the following arguments:

  • Inumber1: Required. The complex number from which to subtract inumber2.
  • Inumber2: Required. The complex number to subtract from inumber1.

Example: Let’s look at some Excel IMSUB function examples and explore how to use the IMSUB function as a worksheet function in Microsoft Excel:

IMSUB Function - How to use IMSUB Function in Excel

Syntax:  =IMSUB(A2,B2)


IMSUB Function in Excel - How to use IMSUB Function in Excel

Based on the Excel spreadsheet above, the following IMSUB examples would return:

Syntax: =IMSUB(A3,B3)
Result: i

Syntax: =IMSUB(A4,B4)
Result: 3+3i

Syntax: =IMSUB(A5,B5)
Result: 0

Syntax: =IMSUB(A6,B6)
Result: 3+2i

Syntax: =IMSUB(A7,B7)
Result: -10+240i

Syntax: =IMSUB(A8,B8)
Result: 8+i

Syntax: =IMSUB(A9,B9)
Result: 2+8i

Syntax: =IMSUB(A10,B10)
Result: 1-13i

Syntax: =IMSUB(A11,B11)
Result: 2-14i

Syntax: =IMSUB(A12,B12)
Result: 87-44j

Syntax: =IMSUB(A13,B13)
Result: 228+216i


  • The formula returns the #NUM! error if the complex number doesn’t have lower case i or j (iota).
  • The formula returns the #VALUE! Error if the complex number doesn’t have correct complex number format.
READ:  How to use CONVERT Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *