How to Get Complex Number Magnitude in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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 numbers 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, BC, and D called Complex Numbers, Real Parts, and Imaginary Parts. 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.

dataset of excel complex number magnitude


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.

using a generic way to excel complex number magnitude

  • Then, hit the Enter button.
  • Consequently, this action will show result 2.

using a generic way to excel complex number magnitude

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

using a generic way to excel complex number magnitude

  • After pressing Enter and copying down the formula, you will get the whole imaginary parts of the complex numbers.

using a generic way to excel complex number magnitude

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

using a generic way to excel complex number magnitude

  • Then, hit Enter.
  • After that, copy down the formula from E5 to E9 cell.

using a generic way to excel complex number magnitude

  • As a result, this command will show the magnitude of given complex numbers.

using a generic way to excel complex number magnitude

This way, you can calculate complex number magnitude in a generic way.


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.


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.


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.


<< Go Back to | Complex Number in ExcelExcel for Math | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Souptik Roy
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo