How to Use IMREAL() in Google Sheets

Description

Returns the real coefficient of a complex number.

How To Actually Use IMREAL() in Sheets

IMREAL(complex_number)

Try IMREAL yourself

In cells B1:B10, you have complex numbers in the format 'a+bi'. Use the IMREAL function in cell C1 to extract the real part of the complex number in B1, and then drag the formula down to C10.

Your formula

Hints (2)

Locale Separator ,

Official Docs

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 BetterSheets.co/formulas

Transcript-matched member videos for IMREAL(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Unlock these tutorials

Learn more about the IMREAL() formula:

Generate a IMREAL() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses IMREAL(). 2 free AI generations, no signup. Members get unlimited use.

Generate a IMREAL() formula

How to Use IMREAL() in Google Sheets

Try IMREAL yourself

More related tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values