IMNL Excel Formula

Author Zaheer    Category Formulas     Tags , ,

Excel is a spreadsheet that allows you to do calculations, provides charts and graphs to your results, and has built-in statistical functions. These functions range from Text Function, Lookup Function, Financial Function, Engineering Function and many others.

This article will be dealing with the Engineering Function of Excel. This Excel function allows you to calculate certain of engineering equations in the easiest and shortest process as possible. One of Engineering Function offered by Excel is the IMNL function. This makes the complex number return to its natural algorithm.

The syntax or series of arguments of the IMNL function is IMNL(inumber). In this argument, the inumber refers to a complex number. These complex numbers are already stored in Excel as text. A complex number is interpreted when on the built-in complex number functions of Excel a text string is provided. The imaginary coefficient of complex numbers is zero which means that these numbers can also accept simple numeric values.

The inumber can be in the argument for the IMNL function can be in the form of a complex number. Also, it could be a complex number enclosed in quotation marks which will look like this; ā€œ1+2iā€. Another case could be a source cell which already contains the numeric value or the complex number. Lastly, it could be a value which has been returned through a formula or an Excel function.

You can try the IMNL function by opening an Excel worksheet. Next, select cell A1 and input the function =IMNL(2). The results would be 0.693147180559945. Hit Ctrl+` (grave accent) to change viewing from results to viewing the formulas. You can also view the on the Formulas tab by selecting Formula Auditing group and clicking on the Show Formulas button.

An error on the value which is #VALUE! will occur when the inputted argument on the inumber is not known as a real or imaginary number. Also, if the error result of #NAME? Will appear just follow the steps bellow.

Before being able to use this function first, enable the Analysis ToolPak in Excel. You can do this selecting the Tools and on the drop-down menu select Add-Ins. The window for Add-Ins will pop up then select Analysis ToolPak and hit OK. This process is for Excel 2003, for Excel 2007 and 2010 first select on the spreadsheet select the Excel Options. Select on the Add-Ins and in the Manage box hit Excel Add-Ins and hit Go. After doing so, the Add-Ins window will appear and select Analysis ToolPak and click on OK.

Post comment