# COMPLEX

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function converts real and imaginary coefficients into a complex number.

## Syntax

COMPLEX(*realcoeff*,*imagcoeff*,*suffix*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *realcoeff* | Coefficient of the real part of the complex number |
| imagcoeff | Coefficient of the imaginary part of the complex number |
| *suffix* | (Optional) Suffix of the imaginary part of the complex number, may be either "i "or "j". If omitted, "i" is used. |

## Remarks

For the suffix, use lowercase for "i" and "j" to prevent errors.
An error is returned if the real or imaginary coefficients are non-numeric.
For more information, refer to [Complex Numbers in Engineering Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsengineer/formulas-complexnumbers).

## Data Types

Accepts number and string data. Returns string data.

## Examples

`COMPLEX(3,5)`
`COMPLEX(3,5,"j")`

## Version Available

This function is available in product version 2.0 or later.

## See Also

[IMAGINARY](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMAGINARY) \| [IMREAL](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMREAL) \| [Engineering Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsengineer) \| [Complex Numbers in Engineering Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsengineer/formulas-complexnumbers)