Formulas > =IMAGINARY()

How To Use IMAGINARY() Function in Google Sheets


Returns the imaginary coefficient of a complex number.

Common questions about the IMAGINARY formula include:

• What does the IMAGINARY formula do?
• What is the syntax for the IMAGINARY formula? 
• How do I use the IMAGINARY formula in Google Sheets?

The IMAGINARY formula can be used to return the imaginary part of a complex number. It is typically used to extract the imaginary part of a complex number stored in a cell, and returns it as a real number. 

The IMAGINARY formula can be commonly mistyped as IMAGNARY, IMAGENARY, or IMIGINARY.

Some common ways the IMAGINARY formula is used inappropriately include using it as a general math function, or trying to use it to compute imaginary numbers.

Some common pitfalls when using the IMAGINARY formula include confusing the imaginary part of a complex number with the modulus or phase, or forgetting that the result of the function will always be a real number.

Common mistakes when using the IMAGINARY Formula include putting the cell address in the wrong place and forgetting to include the parentheses in the syntax.

Common misconceptions people might have with the IMAGINARY Formula include that it can be used to calculate imaginary numbers, or that the output of the formula is an imaginary number. However, this is not the case, as it always returns a real number.

How To Actually Use IMAGINARY() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Generate a IMAGINARY() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.