Formulas > =COMPLEX()
How to Use COMPLEX() in Google Sheets
Description
How To Actually Use COMPLEX() in Sheets
COMPLEX(real_part, imaginary_part, [suffix])
Try COMPLEX yourself
In cells A1 and B1, enter the real and imaginary parts of a complex number. In cell C1, use the COMPLEX() formula to create the complex number using A1 and B1.
Hints (2)
-
Remember to reference the correct cells for the real and imaginary parts.
-
The COMPLEX function requires two arguments: real and imaginary.
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
Learn more about the COMPLEX() formula:
Generate a COMPLEX() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses COMPLEX(). 2 free AI generations, no signup. Members get unlimited use.
Generate a COMPLEX() formula