IMDIV Function in Google Sheets

Divide two complex numbers using the IMDIV function.

IMDIV Function

The IMDIV function in Google Sheets divides one complex number by another.

Syntax

IMDIV(dividend, divisor)
  • dividend: The complex number to be divided.
  • divisor: The complex number by which to divide.

Examples

  1. Basic Division

Divide the complex number 2+3i by 1+2i:

=IMDIV("2+3i", "1+2i")

This will output 1.6+0.2i.

Notes

  • The complex numbers should be in text format (e.g., “2+3i” and “1+2i”).
  • IMMULT: Multiply two complex numbers.
  • IMSUB: Subtract one complex number from another.