Google Sheets | IMPRODUCT | Function | Prod. of Complex Numbers | Example | Spreadsheet | Tutorial

Use the Google Sheets IMPRODUCT function to multiply one or more complex numbers. A complex number consists of a real number and an imaginary number. The later has either i or j as the suffix.

All the complex numbers should have the same suffix. If one complex number has i as the suffix and another complex number has j, then the function will return the #NUM error.

The IMPRODUCT function needs only one argument. If only one argument is supplied, then the function returns the argument.

-------------------------------------
How to Use MOD in Google Sheets?

If you wish to get only the remainder of a division operation, use the MOD function:

   • Google Sheets | MOD | Function | Exam...  
-------------------------------------
How to Use QUOTIENT in Google Sheets?

Use the QUOTIENT function to get only the quotient part of the result of a
division operation:

   • Google Sheets | QUOTIENT | Function |...  
-------------------------------------
How to Get Number of Weeks between Dates in Google Sheets?

Here is the link to the step-by-step video tutorial on getting the number of weeks between dates and also the number of fractional days:

   • Google Sheets | Get Number of Weeks B...  
-------------------------------------
How to Use ROUND, ROUNDUP, and ROUNDDOWN in Google Sheets?

Get to know more about these three functions with this step-by-step video tutorial:

   • Google Sheets | ROUND | Function | RO...  
-------------------------------------
How To Use LCM in Google Sheets?

This is the link to the step-by-step video tutorial on using the LCM function to get the least common multiple of one or more numbers:

   • Google Sheets | LCM | Function | Exam...  
-------------------------------------

The format of the IMPRODUCT function formula is:

=IMPRODUCT(factor1, [factor2], […])

Start the equation with an equal-to symbol.

IMPRODUCT is the name of the function.

factor1 is the first complex number to be multiplied with another number or by 1, if factor2 is omitted.

factor2 and others are optional, and is the second and other numbers to be multiplied with factor1.

factor1, factor2, or both, can be, for example, a hard-coded complex number, cell address, or range.

Here are some examples of the IMPRODUCT function formula:

Example 1

=IMPRODUCT(5+2i, 7+2i)

The function returns 31+24i as the product of the two complex numbers.

Example 2

=PRODUCT(A2, B2)

Assume that the cell A2 and B2 have the values of 3+6j and 1+2j respectively. The function returns -9+12j.

The real part of the complex number is negative, because j-square is -1.

Example 3

=PRODUCT(C7,D7)

Assume that the cells in the range C7 and D7 have 3+2i and 5-6j as the values respectively. The function returns the #NUM error, because each of the two complex numbers has a different suffix.

Review this video tutorial, which gives the steps to use the Google Sheets IMPRODUCT function with examples.