logo
excelfunctions.org
bookmarks

IMAGINARY

Returns the imaginary coefficient of a complex number.

EngineeringEngineering & Science

What it does

Extracts the imaginary part of a complex number.

Syntax

IMAGINARY(inumber)

Arguments

  • inumber(text) β€” Complex number.

Examples

Get Imaginary

Extract from 3+4i.

FORMULA
=IMAGINARY("3+4i")
RESULT
4
SAMPLE DATA
A
1Comp
23+4i