# Learn How to Use Microsoft Excel IMPRODUCT Function

Written by | 0 Comments | 836 Views

In this article, you will learn how to use the Microsoft Excel IMPRODUCT function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel IMPRODUCT function return value and syntax with the help of some examples.

## Microsoft Excel IMPRODUCT Function

The prime function of the Microsoft Excel IMPRODUCT function is to get the product of complex numbers. So, with the help of IMPRODUCT function, you can able to return the product of one or more complex numbers. The complex number should be in the form of  "x + yi" or "x + yj". You can also use the COMPLEX function to create complex numbers from real and imaginary parts.

### Return Value of IMPRODUCT Function

The return value will be the product of the complex numbers.

### Syntax of IMPRODUCT Function

=IMPRODUCT(number1, [number2], ...)

Where the arguments:

number1: It is complex number 1.

number2: It is complex number 2.

## How to Use Microsoft Excel IMPRODUCT Function?

As we know that IMPRODUCT function you can able to return the product of one or more complex numbers. The complex number is input in the form text as,  "x + yi" or "x + yj". The result of the function will be the complex number as a text.

It should be noted that only lowercase "i" and "j" are accepted by the IMPRODUCT function and other values will result in a #NUM! error. The IMPRODUCT function can manage up to 255 numbers.