# IMABS Excel Formula

Microsoft Excel helps us in our daily simple and complex computations. This is possible because of the Excel functions. These functions are shortened and simplified for a more convenient and easy way to do calculations.

Microsoft Excel is software application distributed by Microsoft. Excel allows you to do graphs and pivot tables, compute and calculate values, and do Visual Basic Applications. You can manage your records and data in Excel, do inventory, corporate budgeting and other related activities.

The functions in Excel are Text Functions, Logical Functions, Database Functions, Math Functions, Statistical Functions, Engineering Functions, and many others. These functions are the grouped into smaller groups for easy recognition. Also, these functions will lessen your burden in using the long formulas and functions in a specific filed. For example, Engineering functions are used to calculate Binary Numbers, Bessel Functions up to the conversion of different bases.

Another Engineering function is known as IMABS function which allows you to return the absolute values of a given numerical value.

If you encounter the #NAME? error while using any of function then you must first enable and load Analysis Tool Pak Add-Ins. For you to perform this, select first the Tools in the menu bar and choose the Add-Ins. After, select in the Add-Ins list the Analysis Tool Pak and hit the OK option.

**The syntax of MABS function include:**

** IMABS(inumber)**

…wherein the argument Inumber refers to the value of complex number which you wan absolute value. Remember that to use when you use complex you will convert imaginary and real coefficients to complex number.

Value of the Inumbers argument could be simple numbers or complex numbers which must be enclosed in quotation mark. In addition, the Inumber value can also be source cell which can have the simple or complex number. A numerical value, which has been returned by an Excel formula or function, can also be a value of Inumber argument.

Open a blank Excel worksheet or spreadsheet to try the function. In cell A1 input the formula =IMABS (“5+12i”) which will give a value of 13. This means that absolute value 5+12i is 13. Also, try to input the formula =IMABS (6) and the result of it will be 6. This means that the absolute values, the number 6 is also 6.

If you would like to view the formula of the results, you can do this by hitting the Ctrl+` (grave accent) keys. Also, by hitting Formulas tab and in it select Formula Auditing groups options and from it hit the button which says Show Formulas.

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