Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelIMAGINARY Function in Excel

# IMAGINARY Function in Excel

## IMAGINARY Function in Excel

This function in Excel returns the imaginary coefficient of a complex number given in the form x + yi or x + yj.

#### Syntax

=IMAGINARY (inumber)

ArgumentsÂ

• inumberÂ â€“ A complex number from which we need to extract the imaginary co-efficient.

## How to use IMAGINARY function in Microsoft Excel?

Using this function in an excel worksheet is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

To find out the imaginary coefficient of the complex numbers, Enter the complex numbers in column A and enter the following formula in Column B,

Formula: =IMAGINARY (A1)

Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the imaginary coefficient of the complex form.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021