IMAGINARY
Formulas / IMAGINARYCalculate the imaginary coefficient of a complex number.
==IMAGINARY(inumber)
- inumber - required, a complex number
Examples
=IMAGINARY("0-j")TheIMAGINARY function can also be used to return an imaginary coefficient from a complex number with a negative coefficient. This returns -1, the imaginary coefficient of the complex number 0-j.
=IMAGINARY(4)The IMAGINARY function can also accept a numerical argument, as long as it is an imaginary coefficient. For example, the abve formula returns 0, which is the imaginary coefficient of 4.
Need help with Formulas?
Summary
The IMAGINARY function is a powerful tool for working with complex numbers, allowing users to quickly and accurately retrieve the imaginary coefficient of a complex number in textual format.
- The IMAGINARY function is used to return the imaginary coefficient of a complex number. It accepts a complex number as its argument.
Frequently Asked Questions
What is the IMAGINARY function?
The IMAGINARY function is a formula used to return the imaginary coefficient of a complex number. The imaginary coefficient is the coefficient of a complex number in text format x + yi or x + yj.
What is the syntax of the IMAGINARY function?
The syntax of the IMAGINARY function is IMAGINARY(number).
What is the inumber argument?
The inumber argument is a required argument that is a complex number.
What does the IMAGINARY function return?
The IMAGINARY function returns real values.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV