IMSUB Function in Google Sheets

Subtract one complex number from another using the IMSUB function.

IMSUB Function

The IMSUB function in Google Sheets subtracts one complex number from another.

Syntax

IMSUB(first_number, second_number)
  • first_number: The complex number from which to subtract. This is a required parameter.
  • second_number: The complex number to subtract. This is a required parameter.

Examples

  1. Basic Usage

Subtract the complex number 2+3i from 5+4i:

=IMSUB("5+4i", "2+3i")

This will output 3+1i.

Notes

  • The complex numbers can be provided as strings, e.g., ā€œ5+4iā€.
  • The function works with any valid complex number format.
  • IMADD: Add two complex numbers.
  • IMDIV: Divide one complex number by another.