Excel COMPLEX Function

What is COMPLEX function in Excel?


The COMPLEX function is one of the Engineering functions of Excel.

It Converts real and imaginary coefficients into complex numbers.

We can find this function in Engineering of insert function Tab.

How to use COMPLEX function in excel

  1. Click on an empty cell (like F5 )
 empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

 insert function tab in excel

4. Select Engineering category.

5. Select COMPLEX function.

6. Then select ok.

COMPLEX function in excel

7. In the function arguments Tab you will see COMPLEX function.

8. Real_num section is the real coefficient of the complex number.

9. l_num section is the imaginary coefficient of the complex number.

10. Suffix section is the suffix for the imaginary component of the complex number.

11. You will see the results in the formula result section.

How to use COMPLEX function in excel

Examples of COMPLEX function in Excel

Example 1:

How to use COMPLEX function in excel

You can see examples of COMPLEX function below:

Examples of COMPLEX function in Excel
complex(A2,B2) ----->>>>answer is  1+3i

complex(A3,B3) ----->>>>answer is  1+3i

complex(A4,B4) ----->>>>answer is  2+4i

complex(A5,B5) ----->>>>answer is  2+4i

Purpose of COMPLEX function

It Converts real and imaginary coefficients into complex numbers.

Return value of COMPLEX function

It returns a number.

Arguments of COMPLEX function

This function has just 2 Argument.

The argument of COMPLEX function is number.

Real_num section is the real coefficient of the complex number.

l_num section is the imaginary coefficient of the complex number.

The argument of COMPLEX function is required and not optional.

COMPLEX(number) = number

Version of excel supports COMPLEX function

This function is available for all excel versions (2003-2019)

Errors in COMPLEX function

COMPLEX related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *