How to Use Excel's COMPLEX Function

Excel's COMPLEX function converts the specified real and imaginary coefficients into a complex number. A complex number has the form x+yi where x is the real component, y is the imaginary component and i is the square root of -1.

Instructions

Difficulty: Moderate

1. Install the Analysis ToolPak if COMPLEX returns the #NAME? error value. Select the Add-Ins menu item from the Tools menu, check the box next to the Analysis ToolPak and click on the OK button to install the Analysis ToolPak.
2. Learn the syntax for COMPLEX. It's COMPLEX(real_num,imaginary_num[,suffix]) where real_num is the real coefficient, imaginary_num is the imaginary coefficient and suffix is an optional argument that specifies the character that will represent the square root of -1.
3. Use valid values for suffix. These may be “i” or “j” with “i” being the default value. All functions involving complex numbers will accept a suffix of “i” or “j” but the suffixes in a given argument list must be the same. The suffix is case sensitive, therefore “I” or “J” will not be accepted.
4. Interpret the error values that may be returned by COMPLEX. The #VALUE! will be returned if real_num or imaginary_num are non-numeric or a suffix other than “i” or “j” is specified.
5. Look at some examples of COMPLEX that do not specify a suffix. =COMPLEX(2,3) will return 2+3i. =COMPLEX(0,1) will return i since 0+1i = i and =COMPLEX(1,0) will return 1 because 1+0i = 1. =COMPLEX(2,3,”j”) will return 2+3j but COMPLEX(2,3,J) will return #VALUE! because suffix is case sensitive.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.