Returns the absolute value (modulus) of a complex number.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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")결과: 5
Calculates the modulus of 3 + 4i, which is the square root of (3^2 + 4^2).
The function will return the #NUM! error.