IMLOG2 Excel Formula

Excel has many features which will help you in your daily processing and computing activities. These functions are readily available for usage such as the Engineering function. This function allows you do engineering computations which are commonly related to Complex Numbers, Bessel Functions, and conversion of bases.

Before being able to use the Excel functions specially for first timers you have to enable the add-ins first. For Excel 2003, on the Tools menu select the Add-Ins. A window will pop-up and on the options select Analysis ToolPak and hit OK.

For those who have Excel 2010 and 2007 open first an Excel spreadsheet. On the upper left click on the Excel Options and from the options select the Add-Ins. The Manage box will appear and select from the list the Excel Add-Ins and hit Go. The Add-Ins window will appear and on the selection click the Analysis ToolPak and hit OK.

After enabling the Analysis ToolPak, you can now make use of the  Engineering Functions in Excel. One of these that you can work with is the Excel IMLOG2. This function can be used in a given complex number to calculates its base 2 logarithm. The syntax of IMLOG2 is IMLOG2(inumber). In this argument, the inumber refers to a complex number. Also, the inumber must also be enclosed in quotation marks.

After enabling the Analysis ToolPak on your Excel try to input the example functions to find the base 2 logarithm of the following complex numbers. On the A1 cell input =IMLOG2(“5+2i”) and the results would be 2.42899049756379+0.548954663286635i. You can also try another example which is =IMLOG2(“2-i”)the results will be 1.16096404744368-0.668902106225488i. On the other hand, you can also input an inumber in the argument without enclosing it in parenthesis such as IMLOG2( 6 ) which will result to 2.58496250072116.

If the inputted inumber is not recognized as a complex number, an error of #NUM! will occur. An error #NAME? will also occur if the Analysis ToolPak is not enabled.

To change viewing from the results to the formula and vice-versa you can hit Ctrl+` (grave accent). You can also this by clicking on the Formula tab and on the Formula Auditing group hit the Show Formula button.


Post comment