**Excel IMLOG10**

# IMLOG10 Excel Formula

There are a lot of Engineering Functions in Excel that are very useful. One of this is the IMLOG10 function which returns the base 10 of a logarithm of a supplied complex number. The argument of the function is IMLOG10( inumber ) wherein the inumber is represented by a complex number.

If in trying the function the #NAME? Error will occur, this means that you will be needing to enable the Analysis ToolPak. For Excel 2007 and Excel 2010, you can enable this** **by selecting the Excel Options button on your spreadsheet. Next, on the menu select the Add-Ins and the Manage box will appear. On the box select the Excel Add-Ins and click Go. The Add-Ins window will appear and from the window select the Analysis and ToolPak and hit OK.

For Excel 2003, select form the Tools drop-down list the Add-Ins option. The Add-Ins window will pop up and on the list select the Analysis ToolPak options and hit OK.

After enabling the Analysis ToolPak also take note that in the Excel complex numbers are already stored. Therefore, if in a text string is supplied in a format of “a+bi” it is then interpreted as a complex number. Simple numeric values are also accepted as complex number functions because it imaginary coefficient is also zero.

The inumber in the function IMLOG10( inumber ) can be in the form of a simple number and a complex number enclosed in quotation marks. Also, the inumber can be a reference cell which contains a number or a complex number. It can also be a number returned from a function or formula in Excel.

Open an Excel spreadsheet and enable the Analysis ToolPak. After doing so, on cell A1 enter the following function =IMLOG10(2) and the results will be 0.301029995663981. For a source cell, enter the inumber in cell A2 which is 2.5-i and enter the function =IMLOG10(A3) in cell B3, the results would be 0.430169003285497-0.165251819908898i.

If the error #VALUE! Appears in the cell this means that the inputted inumber is now a know imaginary number or real number.

## 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