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

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