Engineering functions in **Microsoft Excel** perform calculations that relate to the Bressel function, Complex numbers, or converting between different bases. In Microsoft Excel, the **IMPRODUCT function** is an Engineering function; its purpose is to return the product of 1 to 255 complex numbers. In mathematics, a complex number is a number system containing real and imaginary numbers; it can be expressed in the form of a + bi, where a and b are real numbers. You can use the IMPRODUCT function to calculate both Product of two complex numbers or a product of a complex number and a number.

The **formula** for the IMPRODUCT function is `IMPRODUCT(inumber1, [inumber2]….)`

.

The **syntax** for the IMPROPER function is below:

**Inumber 1**: Complex number 1; is required.**Inumber 2**: Complex number 2 (optional).

## How to use the IMPRODUCT function in Excel

Follow the steps below to use the IMPRODUCT function in Microsoft Excel:

- Launch Microsoft Excel.
- Create a table or use an existing table from your files.
- Place the formula into the cell you want to see the result.
- Press the Enter key to see the results.

Launch **Microsoft Excel**.

Create a table or use an existing table from your files.

Place the formula **=IMPRODUCT(A2, B2)** into the cell you want to see the result.

Press the Enter key to see the result.

Drag the fill handle down to see the other results.

There are two other methods to use the IMPRODUCT function.

**Method one** is to click the *fx* button on the top left of the Excel worksheet.

An **Insert Function** dialog box will appear.

Inside the dialog box, in the section **Select a Category**, and select * Engineering *from the list box.

In the section **Select a Function**, choose the *IMPRODUCT *function from the list.

Then click *OK.*

*A ***Function Arguments*** dialog box will open.*

- In the
*Inumber1*entry box, type cell*A2*. - In the
*Inumber2*entry box, type the*B2*.

Then click* OK.*

**Method two** is to click the **Formulas **tab and click the *More Functions *button in the *Function Library* group.

Then hover the cursor over *Engineering* in the drop-down menu and select the I*MPRODUCT* function.

Then select *IMPRODUCT *from the drop-down menu.

A **Function Arguments** dialog box will open.

Follow the same method in **Method 1**.

Then click *Ok*.

### What is Function in MS Excel?

Functions are predefined formulas that perform calculations by using certain values known as arguments, which are placed in a particular order or structure. In Microsoft Excel, functions can be used to perform simple or complex calculations. Excel provides various functions that users can use for calculations.

### How do you write an equation for a function?

Excel functions are written with an equal sign; if it is not written with an equal sign, the formula will not bring out a result. When you write a formula, you will see the syntax of that formula between the brackets, describing what you should input in the formula to give a result.

**READ:** How to use the IMPOWER function in Microsoft Excel.

We hope this tutorial helps you understand how to use the IMPRODUCT function in Microsoft Excel; if you have questions about the tutorial, let us know in the comments.