IMPRODUCT Excel Formula
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.
Further readings
Post comment
Categories
Recent Posts
- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro
Random Posts
- ACCRINT Excel Formula
- How to Update the Data in a Pivot Table
- TRUNC Excel Formula
- IMPOWER Excel Formula
- SQRTPI Excel Formula
- NPER Excel Formula
- How To Export A Microsoft Excel Table To Microsoft Access
- DATEVALUE Excel Formula
- RANDBETWEEN Excel Formula
- How To Print Tables And Charts in Microsoft Excel