IMAGINARYfunction in Google Sheets returns the imaginary coefficient of a given complex number. The imaginary coefficient is the part of the complex number that is multiplied by the imaginary unit. This function is often used in engineering and scientific applications that involve complex numbers.
- How to use
- Examples of using
IMAGINARYformula not working?
- Similar formulas to
IMAGINARY formula with the syntax shown below, it has 1 required parameter:
- complex_number (required):
The complex number for which to return the imaginary coefficient. The complex number can be supplied as a number, cell reference, or another formula that evaluates to a complex number.
ExamplesHere are a few example use cases that explain how to use the
IMAGINARYformula in Google Sheets.
Calculate the imaginary part of a complex number
IMAGINARY function can be used to extract the imaginary part of a complex number, which is useful in many engineering and scientific applications.
Calculate the phase angle of a complex number
The phase angle of a complex number can be calculated using the
REAL functions together in a formula.
Calculate the imaginary coefficient of a range of complex numbers
IMAGINARY function can be used with an array formula to calculate the imaginary coefficients of a range of complex numbers.
IMAGINARYnot working? Here are some common mistakes people make when using the
IMAGINARYGoogle Sheets Formula:
Not using a valid complex number format
The parameter for
IMAGINARY must be a valid complex number. If you get a #NUM error, check that you are using a valid format for complex numbers, such as
Using a cell reference that does not contain a complex number
If you are referencing a cell that does not contain a complex number, you will get a #VALUE error. Check that the cell you are referencing contains a valid complex number.
The following functions are similar to
IMAGINARY or are often used with it in a formula:
COMPLEXfunction returns a complex number based on real and imaginary coefficients. It is commonly used in engineering calculations and signal processing.
SUMIFformula is used to add up values in a range that meet a specific criterion. It can be used to sum values based on text, numbers, or dates. The formula is most commonly used in financial analysis, budgeting, and data analysis.
PRODUCTformula in Google Sheets multiplies all the numbers given in the arguments and returns the product. It is commonly used to calculate the total product of a range of cells.
You can learn more about the
IMAGINARY Google Sheets function on Google Support.