Returns the absolute value (modulus) of a complex number.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
IMABS(inumber)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")Risultato: 5
Calculates the modulus of 3 + 4i, which is the square root of (3^2 + 4^2).
The function will return the #NUM! error.