Syntax
=IMAGINARY(inumber)Arguments
| Argument | Required | Description |
|---|---|---|
inumber | Required | A complex number like "3+4i" |
How to use IMAGINARY
IMAGINARY takes 1 required argument. Type =IMAGINARY( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=IMAGINARY("3+4i")Result =IMAGINARY("0-j")Result =IMAGINARY(4)Result Related engineering functions
- HEX2BINConverts a hexadecimal number to binary.
- HEX2DECConverts a hexadecimal number to decimal.
- HEX2OCTConverts a hexadecimal number to octal.
- IMABSReturns the absolute value (modulus) of a complex number.
- IMARGUMENTReturns the angle (argument) of a complex number, in radians.
- IMCONJUGATEReturns the complex conjugate of a complex number.
- IMCOSReturns the cosine of a complex number.
- IMCOSHReturns the hyperbolic cosine of a complex number.
- IMCOTReturns the cotangent of a complex number.