IMPOWER Excel Formula

Author Zaheer    Category Formulas     Tags , ,

Excel has become part of our daily computing activities. Te built-in functions of Excel also provides the most common engineering calculations which ranges from Bessel, to Complex Numbers up to converting bases.

One of the Engineering Function of Excel that you can use is the IMPOWER function. In this function the given complex number will return it and raise to a given power. The argument or the series of procedure and information of this function is IMPOWER(inumber, number). The inumber in this argument refers to the complex number that you would want to raise to a specific power. While the number refers to the power which you want the complex number to be raised.

The most common error that would occur in this function is the #NAME?, #NUM!, and #VALUE!. The #NAME? Will occur when the Analysis ToolPak is disabled. This can be remedied in Excel 2003 by selecting the Tools and on the drop-down list click on the Add-Ins. The Add-Ins window will appear and select form the list the Analysis ToolPak option and hit OK.

Now, for Excel 2007 and 2010 on the upper left of the spreadsheet select the Microsoft button and click Excel Options. A drop-down list will appear and from it select Add-Ins. The Manage box will pop-up and select the Excel Add-Ins and click Go. After this, the Add-Ins window will appear then select the Analysis ToolPak and hit OK.

If the #NUM! Error will appear this means that the given inumber is not a complex number. Also, if the #VALUE!will appear this means that the given number or complex number in the argument is non-numeric.

Try the function by opening an Excel spreadsheet and in call A1 input the function =IMPOWER(“2-i”, 2) which will have a result of 3-4i. Another example is=IMPOWER(9, 0.5) which will have a result of 3. To change view from formulas to results you can hit Ctrl+` (grave accent).

 

Further readings

Post comment