The IMABS function returns the absolute value of a complex number.
This can be useful in mathematical calculations related to complex numbers and in electrical engineering.
Syntax
IMABS(complex_number)
Argument |
Description |
Permitted values |
|---|---|---|
complex_number |
Complex number in the form of a string for which the absolute value is calculated |
String representing a complex number, for example, “3+4i” or “3+4j” |
Example of use
Calculating the modulus of a complex number
=IMABS("3+4i")
This formula calculates the modulus of the complex number 3+4i.
Result: 5.
Use with the COMPLEX function
=IMABS(COMPLEX(1, 1))
The formula creates a complex number 1+1i using the COMPLEX function, then calculates its modulus.
Result: approximately 1.414.
Impedance calculation in electrical engineering
=IMABS("10+15j")
If the impedance of the circuit is set to 10+15j Ω, the function will return its modulus.
Result: approximately 18.03 Ω.
Use with reference to cell
=IMABS(A2)
If cell A2 contains the complex number 5-12i, the function will return its modulus.
Result: 13.
Notes
–The modulus of a complex number a+bi is calculated by the formula: √(a² + b²).
–The function returns a real number equal to the distance from the point (a,b) to the origin on the complex plane.
–The modulus is always a non-negative number.
–For complex numbers in the format with the “j” suffix, the function works in the same way.