IMAGINARY Function in Excel: Syntax, Examples and Free Practice
IMAGINARY is an Excel Engineering function. Returns the imaginary coefficient of a complex number.
IMAGINARY syntax
=IMAGINARY(inumber)
Arguments
inumber: A complex number in the form "a+bi"
When to use IMAGINARY
A specialized function used in scientific and engineering calculations rather than typical day-to-day business reporting.
Practice IMAGINARY online, free
Open the live Excel-style spreadsheet and try IMAGINARY yourself. No Excel install or sign-up needed to start.
Practice IMAGINARY now →More Engineering functions
Frequently asked questions
What does the IMAGINARY function do in Excel?
Returns the imaginary coefficient of a complex number.
What is the syntax of IMAGINARY in Excel?
The syntax is =IMAGINARY(inumber). inumber: A complex number in the form "a+bi".
Where can I practice IMAGINARY online for free?
Open the free live spreadsheet on Cellgrids and try IMAGINARY yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Engineering functions · Excel case studies · Excel tutorials · Excel shortcuts