IMABS(inumber)
=IMABS("5+12i")
The IMBAS function in Sourcetable can be used to calculate the absolute value of a complex number that is represented in exponential notation. This returns a value of 13, which is the absolute value of the complex number 5+12i.
=IMABS("3+4i")
The IMBAS function can also be used to calculate the absolute value of a complex number that is represented in rectangular coordinates. This returns a value of 5, which is the absolute value of the complex number 3+4i.
The IMABS function returns the absolute value of a complex number (represented by x + yi or x + yj), which is the magnitude of the complex number.