IMSUB

Returns the difference between two complex numbers.

Sample Usage

IMSUB("6+5i", "2+3i")

Syntax

IMSUB(first_number, second_number)

  • first_number - The complex number to subtract second_number from.
  • second_number - The complex number to subtract from first_number.

Notes

  • The difference between two complex numbers is defined as follows:
    • (a+bi) - (c+di) = (a-c) + (b-d)i
  • You can subtract two complex numbers only if they have the same suffix (i or j). For example, you can't do IMSUB("4+3i", "1+2j").

See also

  • COMPLEX: The COMPLEX function creates a complex number, given real and imaginary coefficients.
  • IMREAL: Returns the real coefficient of a complex number.
  • IMAGINARY: Returns the imaginary coefficient of a complex number.
  • IMSUM: Returns the sum of a series of complex numbers or cells or both.

Examples

1 A B
2 Formula Result
3 =IMSUB("6+5i", "2+3i") 4+2i
4 =IMSUB("20+5j", "4j") 20+j
5 =IMSUB("20+5j", "4") 16+5j
6 =IMSUB("20+5j", 4) 16+5j
7 =IMSUB(COMPLEX(20, 5), COMPLEX(4, 0)) 16+5i
Was this article helpful?
How can we improve it?