IMABS Function in Google Sheets

Calculate the absolute value of a complex number using the IMABS function.

IMABS Function

The IMABS function in Google Sheets calculates the absolute value (or magnitude) of a complex number.

Syntax

IMABS(number)
  • number: The complex number whose absolute value you want to calculate. This is a required parameter.

Examples

  1. Absolute Value of a Complex Number

Calculate the absolute value of the complex number ‘3+4i’:

=IMABS("3+4i")

This will output 5.

  1. Absolute Value of a Purely Imaginary Number

Calculate the absolute value of the complex number ‘0+5i’:

=IMABS("0+5i")

This will output 5.

  1. Absolute Value of a Real Number

Calculate the absolute value of the number ‘7’:

=IMABS("7")

This will output 7.

Notes

  • The IMABS function is useful in engineering and scientific calculations involving complex numbers.
  • The absolute value of a complex number is the distance from the origin to the point represented by the complex number in the complex plane.
  • IMAGINARY: Extract the imaginary part of a complex number.
  • IMREAL: Extract the real part of a complex number.