keep in mind javascript is required for full website functionality.
Welcome back to our regular blog of Excel functions from A to Z. Today we look at the COMPLEX function.
The COMPLEX function
Imagine this complex function. This function converts real and imaginary coefficients into a complex number of the form x + yi O x + yj, where I O j denotes the square root of -1.
The COMPLEX function uses the following syntax to operate:
COMPLEX (real_num, i_num, [suffix])
The COMPLEX The function has the following arguments:
- real_num: this is required and represents the real coefficient of the complex number
- i_num: this is also necessary. This denotes the imaginary coefficient of the complex number
- suffix: this argument is optional. The suffix of the imaginary component of the complex number. If omitted, suffix is assumed to be “I“.
NOTE: All complex number functions accept “I” Y “j” by suffix, but neither “I” ni “J”. Using uppercase results in # VALUE! error value, given the potential confusion with cell references etc. All functions that accept two or more complex numbers require all arguments to match.
It should also be noted that:
- And real_num it is not numeric, COMPLEX return the #VALUE! error value
- And i_num it is not numeric, COMPLEX return the #VALUE! error value
- And suffix It is none “I” ni “j“, COMPLEX return the #VALUE! error value
- Las operaciones aritméticas que involucran números imaginarios requieren funciones específicas como IMSUB (sustraer), IMSUM (add), IMPRODUCTO (multiply) Y IMDIV (share). Si no se utilizan, los cálculos devolverán el #VALUE! error value.
Please, see my example below:
Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every other business day.
You can find a full page of feature articles here.
