IMAGINARY

Formulas / IMAGINARY
Calculate 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.

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.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.