Returns the absolute value (modulus) of a complex number.
Синтаксис
IMABS(inumber)Аргументы
inumberобязательно
A complex number for which you want the absolute value.
The IMABS function calculates the absolute value of a complex number in x + yi or x + yj text format. The absolute value is the distance from the origin (0,0) to the point represented by the complex number in the complex plane.
=IMABS("3+4i")→5Calculates the modulus of 3 + 4i, which is the square root of (3^2 + 4^2).
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =IMABS("x+yi") replacing x and y with your real and imaginary components.
The function will return the #NUM! error.