IMSUB

Formulas / IMSUB
Calculate the difference between two complex numbers.
IMSUB(inumber1, inumber2)
  • inumber1 - required, a complex number to subtract inumber2 from
  • inumber2 - required, a complex number to subtract from inumber1

Examples

  • =IMSUB("1+2i",3) returns "-2+2i". This example subtracts 3 from the imaginary number "1+2i". The result is "-2+2i" which is a complex number.

  • =IMSUB("3+4i","1+2i") returns "4i". This example subtracts "1+2i" from the imaginary number "3+4i". The result is "4i" which is a complex number.

Summary

The IMSUB function subtracts two complex numbers and requires two arguments for successful completion.

  • The IMSUB function returns the difference between two complex numbers, both of which must be in the form x + yi or x + yj.
  • To create complex numbers, use the COMPLEX function.


Frequently Asked Questions

What is the IMSUB function?
The IMSUB function is a function used to subtract two numbers.
What are the arguments for the IMSUB function?
The IMSUB function takes two arguments.
Are the arguments for the IMSUB function required?
Yes, the arguments for the IMSUB function are required.
How do I use the IMSUB function?
To use the IMSUB function, you must input two numerical values as arguments. For example, if you wanted to subtract 4 from 7, the code would look like this: IMSUB(7,4).
Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV