# How to Use IMSUB in Google Sheets in 2020?

IMSUBReturns 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”).

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

Categories Uncategorized Tags