IMPRODUCT Excel Formula

Author Zaheer    Category Formulas     Tags , ,

Excel has a lot of functions which can be used in many different fields as one of this is its Engineering Functions. These Engineering Functions of Excel makes the computing a lot faster and easier because of its built-in functions.

But before using any of these functions you must first enable the Analysis ToolPak in Excel. An error of #NAME? will occur if the particular add-in is not enabled. For Excel 2003 you can work on this by hitting first the Tools and on the drop-down menu select the Add-Ins. When the Add-Ins window is going to pop-up, then you should select from the list the Analysis ToolPak and hit OK. For Excel 2007 and 2010 click the Microsoft button on the top left of the spreadsheet and hit the Excel Options. An menu list will appear and from it select the Add-Ins. On the Manage tab, you need to select the Excel Add-Ins and click Go. The Add-Ins window will appear and from it select the Analysis ToolPak and hit OK.

Now, you can use the IMPRODUCT function which enables you to calculate the product of complex numbers may it be two or more. The argument of the function is IMPRODUCT (inumber1, inumber2…). The inumber1, inumber2,… refers to the complex numbers between 2 and 29.

Take heed that the complex numbers are store text in Excel. A complex number is also considered in the format of “a+bi” when used in one of the functions of Excel. Moreover, the inumber can also be in the form of a simple number or a complex number enclosed in quotation marks. Also, it can be a value which was returned by using an Excel formula or function. A reference cell can also be an inumber provided that it contains numeric value or a complex number.

Try the following function in a blank Excel spreadsheet. First, input in cell A1 the formula 1-i and input the function in cell B1 =IMPORDUCT (A1, A2) the result in B1 would be 15+5i. Another function would be, =IMPORDUCT (COMPLEX (5, 2), COMPLEX (0, 1)) which will result to -2+5i.

If in case an error of #NUM! Will occur, this means that the given inumber in the argument is not a complex number.

Post comment