IMPOWER Excel Formula
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
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