Microsoft Excel is a handy software. We use Excel functions for our educational, business, and other daily purposes. We operate the Excel IMABS function for various complex mathematical problems. While dealing with complex numbers, we can find the absolute values easily by implementing this function. With this in mind, we will show you 5 practical examples of how to use the Excel IMABS function.
Excel IMABS Function: Summary & Arguments
Excel IMABS function generally returns the absolute value or the modulus of a complex number where the complex number is in x+yj or x+yi format. Mathematically, it represents the equation:
where z = x+yi.
The syntax of the IMABS function is as follows:
|inumber||Required||A simple/complex number to calculate the absolute value.|
● Return Value:
It returns the absolute values of the complex numbers.
Office 365 ￭ Excel 2019 ￭ Excel 2016 ￭ Excel 2013 ￭ Excel 2011 for Mac ￭ Excel 2010 ￭
Excel 2007 ￭ Excel 2003 ￭ Excel XP ￭ Excel 2000.
Excel IMABS Function: 5 Practical Examples
Calculating the absolute values of complex numbers can be really cumbersome if we have a large dataset. However, if we supply recognized logical values to the argument, they can return the absolute values quite easily. Furthermore, the IMASBS is also useful for different other cases. We take a dataset representing complex numbers with their real and imaginary numbers to demonstrate. Let’s see some useful examples of the IMABS function in Excel.
1. Insert IMABS Function to Get Simple Numeric Values
In the first example, we have a column that has simple numeric numbers. In another column, we add imaginary Co-Efficient to them. The IMABS function not only returns the absolute values of complex numbers but also calculates for simple numeric numbers. Follow these easy steps to calculate.
- First, in cell D5, type the following formula,
- Afterward, press Enter or Tab button to get the absolute value of cell C5.
- Now, drag the formula cell down to AutoFill the rest of the arrays.
- Thus, we get the simple numeric values in the dataset.
The integer 6 in cell C9 also represents itself as a complex number equal to 6+0i.
Read More: How to Use COMPLEX Function in Excel
2. Calculate Absolute Value of a Complex Number in Quotation
Similarly, we can also obtain the absolute values of complex numbers enclosed in Quotation marks. We can put the real numbers & the imaginary number and encase them in the function arguments with quotation marks. Follow the steps to do so:
- Firstly, in cell D5, write the formula given below,
- Then, tap Enter or Tab button on your keyboard.
- See the picture below to understand better.
- Similarly, do the same to all the rows one by one.
- Hence, the desired values pop up in the dataset.
Read More: How to Use IMAGINARY Function in Excel
3. Find Absolute of Complex Numbers Through Cell Reference
Another way to use the IMABS function is to refer to the cells of the complex numbers. Since we have the real numbers and imaginary numbers already in the complex numbers, we can just put the cell index into the IMABS function. As a result, we get the absolute values quite easily. Let’s see some procedures.
- To begin with, type the IMABS formula in E5, and click on the cell D5,
- Consequently, we have selected the value 2i into the function.
- Finally, hit Enter button.
- As a result, the desired value appears in cell E5.
- Lastly, AutoFill the rest of the array by dragging the cell down.
Read More: How to Use IMDIV Function in Excel
4. Display Value Derived from Another Function Using IMABS
In this example, we will calculate the absolute value of a complex number which is derived from the COMPLEX function. This function combines the real and imaginary components together and forms a complex number. As we have two columns with real values and imaginary values, we put them together using the COMPLEX function. Further, we will include the IMABS function to get the absolute value of the complex number. To do so, follow the steps carefully.
- First, in cell D5, type the following COMPLEX formula,
- Here, the function adds up the real component 2 & imaginary component 3i and forms 2+3i which is a complex number.
- After that, press Enter key.
- Later, AutoFill the range to get the other complex numbers.
- Again, in cell E5, write the IMABS formula:
- Further, tap Enter or Tab button.
- Thus, the desired values pop up in the dataset.
Read More: How to Use IMPRODUCT Function in Excel
5. Combine IMABS & IMSUM Functions to Add Multiple Values
In our last example, we will thoroughly combine the IMABS and IMSUM functions to add multiple complex numbers. The IMSUM function sums up two or multiple complex numbers and returns the sum values. After that, we will use the IMABS function to calculate the absolute values of the returned values. Let’s follow these procedures carefully.
- To begin with, type the following formula in D5:
- Next, press Enter or Tab button to get a result in D5.
- Later, AutoFill the rest of the array by dragging the cell down.
- Finally, we obtain our values in the dataset.
🔍 How Does the Formula Work?
- IMSUM(B5,C5) adds up the complex number in B5 and C5 and returns the sum value.
- IMABS(IMSUM(B5,C5)) calculates the absolute values of the previously returned values.
READ MORE: How to Use IMSUB Function in Excel
Common Errors While Using Excel IMABS Function
|#NUM!||If the supplied inumbers arguments are not recognized as complex numbers.|
|#VALUE!||If the supplied inumbers are logical values.|
Download Practice Workbook
Download this workbook to practice while you are reading this article. It contains all the datasets in different spreadsheets for a clear understanding. Try it yourself while you go through the whole process.
In conclusion, we have discussed some easy steps on how to use the Excel IMABS function.