- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Engineering - COMPLEX Function
Description
The COMPLEX function converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
Syntax
COMPLEX (real_num, i_num, [suffix])
Arguments
Argument | Description | Required/ Optional |
---|---|---|
real_num | The real coefficient of the complex number. | Required |
i_num | The imaginary coefficient of the complex number. | Required |
suffix | The suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be "i". | Optional |
Notes
All complex number functions accept "i" and "j" for suffix, but neither "I" nor "J". Using uppercase results in the #VALUE! Error value.
All functions that accept two or more complex numbers require that all suffixes match.
If real_num is nonnumeric, COMPLEX returns the #VALUE! error value.
If i_num is nonnumeric, COMPLEX returns the #VALUE! error value.
If suffix is neither "i" nor "j", COMPLEX returns the #VALUE! error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_engineering_functions.htm
Advertisements