IMABS
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.