How to Use the IMABS Function in Google Sheets

Today we will learn how to use the IMABS Function in Google Sheets. IMABS is a function of Google Sheets that calculates the absolute value of a complex number in Google Sheets. A complex number is a number that has an imaginary part and is represented by a+bi where “i” is the imaginary part of the number. In this guide, we will see how we can find an absolute value in Google Sheets and how to use the IMABS function in Google Sheets.

Pros of IMABS Function in Google Sheets

In simple terms, if we say, the IMABS function is used to calculate the magnitude of a complex number, where the magnitude is the distance from the origin, we can easily find the magnitude of a complex number in Google Sheets by using the IMABS function. If you want to learn how to use the IMABS function in Google Sheets, go through the following guide.

Syntax

=IMABS(Complex number)

IMABS: Refers to the function name.

Complex number: Refer to a complex number for which we want to find absolute value.

Step-by-Step Procedure – IMABS Function in Google Sheets

The procedure of using the IMABS function is very fine and simple because it has only a single argument in its syntax, you just need to start the function, give the complex number, and get the result as follows.

Step 1

In the following data chart, if you see here, we have a complex number of which we will find the absolute value by using the IMABS function.

Step 2

First, we will start the function in the cell in which you want to get the value. To start the function, place an equal sign and write the name of the function as written below.

Step 3

After starting the function, now we will have to provide a complex number to the function as here we have given the cell reference of the complex number.

Step 4

We have completed the syntax as there was only a single argument so now just, we need to hit the Enter key to get the result.

We will get the absolute value of the given complex number as we have found in the following example.

Step 5

If you don’t have already written a complex number in your sheet, then you can also directly write the complex number into the syntax.

You will have to write the complex number into the quotation marks as I have written below.

Step 6

Once you have written the syntax then press the Enter key, you will get the same results as can be seen below.

How to Use IMABS Function in Google Sheets – FAQs

Q: How to create a complex number in Google Sheets?

A: As we all know to find the absolute value, we need a complex number in Google Sheets. Unfortunately, we cannot directly write a complex number in Google Sheets, we will have to use a Complex function to make a complex number in Google Sheets. Let me show you practically in the following steps.

Step 1

First, we will start the Complex function in the cell.

Step 2

After starting the function, we will have to express the values A and B by giving cell reference or you can also directly write the number into the syntax.

Step 3

In the last, you will have to define the suffix that could be “i” or “j” which is the imaginary part of the complex number.

Step 4

Now, you have just one click to go, press the Enter key and get the result.

Conclusion

In this article, we have learned how to use the IMABS function in Google Sheets, we have also learned how to make a complex number in Google Sheets so you may easily find the absolute value of a complex number in Google Sheets by using the IMABS function.