IMREAL Excel Formula

One of the Engineering Functions of Excel is the IMREAL function which returns the given complex number to a real coefficient. The argument of this function is IMREAL(inumber). The inumber in the argument must be a complex number. These complex numbers are already installed text in the Excel. In the format of the text string “a+bi” which is used in one of the Excel function it is immediately interpreted as a complex number. Moreover, a simple numeric value can also be accepted because its known imaginary coefficient is zero.

In the argument, the inumber can also be in a simple number or a complex number which is enclosed in quotation marks. A cell reference can also be an inumber as long as it contains a numeric value or a complex number. Also, an inumber can be an existing value which was returned by using an Excel function or formula.

There are also certain errors that may occur such as #NAME? error. This means that the Analysis ToolPak add-in has not been enabled. To enable this in Excel 2003 first select the Tool and on the drop-down list hit the Add-Ins. The Add-Ins dialogue box will appear and on it select the Analysis ToolPak and hit OK. For Excel 2007 and 2010 enable it by clicking the Microsoft button in the upper left portion of the spreadsheet. Then select the  Excel Options and from the menu hit Add-Ins. On the Manage box select the Excel Add-Ins and click Go. The Add-Ins window will appear and from it select the Analysis ToolPak and hit OK.

After enabling the Analysis ToolPak Add-Ins you can now try the following functions. On the cell A1  input the formula 5+21 and on cell B1 input the function =IMREAL(A1). This is for the reference cell, the result would be 5. another example is on cell B2 input the function =IMREAL(“2+2i”) which will have a result of 2.

If the #NUM! will occur or appear in the cell this means that the inumber in the arguments is not a complex number.

Post comment