In this article, I will show how to get the magnitude of a complex number in Excel by using 2 easy methods. You may need mathematical calculations when working on an Excel worksheet. Complex number magnitude is a ubiquitous expression in mathematical calculations. In this article, I will show you two effective ways to get complex number magnitude in Excel. This will help you to increase your Excel skills.
Introduction to Complex Numbers
A complex number is an element of a number system consisting of a real part and an imaginary part. Here, the imaginary part is denoted with i and satisfies the equation i^2 = -1. Every complex number is expressed in the a+bi form where a is the real part and bi is the imaginary part of the number. Contrary to historical nomenclature, complex numbers are crucial to many parts of the scientific explanation of the natural world. They are recognized in the mathematical sciences as just as “real” as real numbers.
How to Get Complex Number Magnitude in Excel: 2 Effective Ways
This is the dataset I am going to use in this article for every method. The database contains three columns, B, C, and D called Complex Numbers, Real Parts, and Imaginary Part. I will add another column in the E column to show the results. The dataset ranges from B4 to D9. Hence, follow the steps of every method one by one. Moreover, I have added the necessary illustrations for every step for your better understanding.
1. Using Generic Way to Get Complex Number Magnitude in Excel
Here, I will show you how to get the magnitude of complex numbers in Excel by using a generic way. This is a very simple process. First, you need to know how to calculate the magnitude generally. Now, every complex number is expressed in the a+bi form where a is the real part and b is the imaginary part of the number. I will show you how to get the real and imaginary parts of the complex numbers first. Then, you need to square the coefficient of the real and imaginary parts of the complex number. Then, make a summation of the squares. After that, make a square root of the summation of the squares. I will follow these steps to get the complex number magnitude. However, I have added a new column with the dataset to show the magnitudes of the complex number. Follow the steps given below.
Steps:
- First, write down the following formula in the C5 cell.
=IMREAL(B5)
In this formula, the IMREAL function is used to separate the real part of the complex number.
- Then, hit the Enter button.
- Consequently, this action will show result 2.
- Then, copy down the formula from C5 to C9 cell.
- Then, copy the following formula in the D5 cell.
=IMAGINARY(B5)
Here, the IMAGINARY function is used to separate the imaginary part of the complex number.
- After pressing Enter and copying down the formula, you will get the whole imaginary parts of the complex numbers.
- Now, select cell no. E5.
- Then, write down the following formula in the selected cell.
=
SQRT(C5^2+D5^2)
Here, the SQRT function is used to get the square root of the summation of the squares of the values in C5 and D5 cells.
- Then, hit Enter.
- After that, copy down the formula from E5 to E9 cell.
- As a result, this command will show the magnitude of given complex numbers.
This way, you can calculate complex number magnitude in a generic way.
Read More: How to Add Complex Numbers in Excel
2. Applying IMABS Function
In this section of this article, I will show you how to calculate complex number magnitude in Excel by applying the IMABS function. The procedure is easy. I hope you will enjoy the whole procedure.
Steps:
- First select the C5 cell.
- Then, copy the following formula in the selected cell.
=IMABS(B5)
Here, the IMABS function is used to get the absolute magnitude of the complex numbers.
- After that, press Enter.
- Then, fill handle the formula from C5 to C9 cell.
- As a result of this command, Excel will show you the magnitudes of the complex numbers.
In this way, you can calculate the magnitude of a complex number by using the IMABS function.
Read More: How to Convert Complex Numbers to Polar Form in Excel
How to Sum Complex Numbers in Excel
When dealing with complex numbers, you may need to sum complex numbers. In this section of this article, I will tell you the shortest way to sum complex numbers. I have used two columns here where you can see the complex numbers. Follow the following steps two sums two complex numbers.
Steps:
- First, select the D5 cell and copy the following formula.
=IMSUM(B5,C5)
in this portion, I have used the IMSUM function to get the sum of the complex numbers.
- After pressing the Enter button, the command will show the suggestions.
- Then copy down the formula from D5 to D9.
- Due to this command, you will get the summation of two complex numbers in the D
In this way, you can get summations of complex numbers.
Read More: How to Format Complex Numbers in Excel
Download Practice Workbook
Please download the workbook to practice yourself.
Conclusion
In this article, I have tried explaining how to get a complex number’s magnitude in Excel. I hope you have learned something new from this article. Now, extend your skill by following the steps of these methods. I hope you have enjoyed the whole tutorial. If you have any queries, feel free to ask me in the comment section. Don’t forget to give us your feedback.