Zoho Sheet COMPLEX: Create Complex Numbers with i or j

=COMPLEX(real; imaginary; [suffix])

real is a required real numeric coefficient, a. imaginary is a required real numeric coefficient, b. The optional third argument suffix is the lowercase text "i" or "j"; omitted defaults to "i". Zoho explicitly specifies lowercase; using "I", "J", "k" or an arbitrary label is not a supported option. The suffix is the name of the imaginary unit, not a third numerical component. All examples here use semicolons because that is the exact vendor-documented English-language syntax.

Both numeric coefficients may be negative, positive or zero in ordinary mathematical interpretation. The reference specifically demonstrates a negative imaginary coefficient and a zero real coefficient. It does not document all possible numeric-to-text coercions, blank-cell rules, decimal precision bounds, or the exact representation when both coefficients vanish. Avoid claiming those cases are universally handled one particular way until verified in an actual Zoho workbook.

In A1 type Real, in B1 Imaginary, and in C1 Suffix. Enter the following rows, then put the specified formula in D2, D3 or D4. Formulas with references rather than constants enable controlled changes without manual retyping.

The documentation supplies the three constant formulas =COMPLEX(2;3;"j"), =COMPLEX(1;-4) and =COMPLEX(0;5;"j"). Replacing their constants with cell references is a reproducible reasoned variation, not an observed native test. Enter plain numeric values in A and B, and plain text j without quotes in C; when referenced in the formula, C4 is a cell containing the suffix text, not a literal formula string.

For a+bi, the real part is a and the imaginary coefficient is b. Its modulus is sqrt(a²+b²). Thus 2+3j has modulus sqrt(13), about 3.605551275, and 1-4i has modulus sqrt(17), about 4.123105626. These numerical checks are independent mathematical identities, not claims about the display format returned by COMPLEX. In a linked worksheet, compare =IMREAL(D2) to 2, =IMAGINARY(D2) to 3, and =IMABS(D2) to SQRT(13) after checking each linked function’s own documentation. This gives a practical round-trip audit rather than a visual guess.

Suppose a small electronics lab receives measured resistance and reactance values. Store resistance in A, reactance in B, and an agreed suffix j in C. The formula =COMPLEX(A2;B2;C2) creates a single portable representation of complex impedance R+jX, suitable for passing to Zoho’s documented complex-related functions. If a reactance measurement changes sign, update B2; the imaginary sign changes accordingly. Keep a unit-of-measure column (for example, ohms), because the complex string does not encode units.

To verify measurement quality rather than merely produce text, place =IMREAL(D2) and =IMAGINARY(D2) in separate columns and compare against numeric input columns. A mismatch might indicate unexpected input conversion or an unsupported suffix. For magnitude checks, use =IMABS(D2) and independently calculate =SQRT(A2^2+B2^2); this is a meaningful cross-check with ordinary real arithmetic when the data is valid. Use numerical tolerances rather than textual equality for non-integer coefficients. The formula =COMPLEX(A2;B2) is appropriate when the standard i notation suffices; specify the third argument when a j-based data source matters.

• #VALUE!: Zoho explicitly identifies invalid types and a suffix other than lowercase "i" or "j" as possible causes. Check numeric inputs and the third argument first. =COMPLEX(2;3;"k") is deliberately invalid according to the documented suffix rule; do not present a captured error screenshot because this has not been run in Zoho.
• #NAME!: Check that the name is spelled COMPLEX, text arguments have double quotation marks, and that a referenced named range actually exists. These are categories from Zoho’s shared error list, not proof that each typo leads to the same code.
• #REF!: Inspect deleted or moved references, especially if a formula uses cells A2/B2/C2. A broken reference cannot be repaired by changing suffix notation.
• #N/A!: Zoho lists this among its general possible errors; the COMPLEX page does not document a specific ordinary coefficient input that makes COMPLEX return #N/A!.
• Unexpected + or omitted zero term: A representation such as 5j is intentionally shown by Zoho, so do not assume it must read 0+5j. Compare numeric components using IMREAL/IMAGINARY rather than concatenated strings.
• Decimal or separator confusion: Confirm the editor’s function syntax and workbook locale before changing semicolons or decimal points. Do not insert locale-specific delimiters into literal complex-number text without supporting documentation.

IMREAL extracts the real coefficient; IMAGINARY extracts the imaginary coefficient; IMABS returns the magnitude. The vendor also documents IMSUM for adding complex numbers. Its existence is a verified related-link reference; IMSUM has a separate function reference.

Is "j" optional? Yes. Zoho states that omitted suffix defaults to the lowercase i convention. Include "j" when the surrounding model convention requires j.

Can COMPLEX add or multiply numbers? Its documented purpose is constructing a complex representation from coefficients. Zoho separately documents IMSUM and IMPRODUCT for arithmetic; do not assume the + operator on two text representations performs complex addition without testing.

Does this prove compatibility with imported Excel formulas? No. Zoho documents supported file types, not exhaustive formula parity. Compare values after import, particularly the suffix and component extraction.

What version introduced COMPLEX? The checked official function page does not provide a first-supported version, so no release claim is made.

This is a guide to Zoho Sheet, based on its public English-language function help, retrieved on 13 October 2026. The vendor examples display semicolons between arguments. Copy the formulas exactly into an English-language Zoho Sheet worksheet using the illustrated syntax; if a workbook uses different regional or language preferences, consult the editor’s displayed function helper and its locale settings rather than silently replacing separators. Zoho documents configurable spreadsheet locale, language and calculation preferences; this guide does not infer a particular separator for every account or locale. The function article does not give a first-supported release, minimum plan, exhaustive mobile compatibility or an exact back-end engine build, so none is asserted here. The documentation establishes the function’s availability in the public Zoho Sheet reference, not execution in our account.

A formula beginning with = is an instruction for an actual spreadsheet. The expected result columns above come from Zoho’s own examples where explicitly marked, or independent mathematical evaluation where marked; none was executed in Zoho Sheet. Mathematical agreement does not prove how every string input, cell formatting choice, import conversion or edge case is handled by Zoho. This distinction matters especially for string representations of complex numbers, which should not be mistaken for a separate native complex-number cell type.

How to reproduce the examples

Create a blank sheet, enter each specified input into its designated cell and paste the formula into a different cell. Check that the input is a value rather than a string containing a leading apostrophe unless the formula specifically calls for text. Read the formula result in the cell and, if helpful, inspect the formula bar to distinguish the stored expression from what is displayed. Do not use formatted example text as proof of an exact output representation unless Zoho explicitly shows it. For comparison across regional settings, first record the workbook locale and whether the formula editor inserts semicolons. Keep a simple control case from Zoho’s own documentation in the same sheet.

Compatibility and source limits

Zoho lists .xlsx, .xls, .xlsm, .ods, .csv and other import formats in its file-format guide. File import support is not evidence that a complex-number formula will calculate identically in another spreadsheet application. When exchanging workbooks, verify the formula survived import/export, that suffix text remains lowercase where required and that outputs retain their meaning. For CSV export, remember that CSV preserves displayed values, not a working formula workbook; inspect an exported copy rather than assuming formulas survive. This guide makes no untested assertion of parity with Excel, Google Sheets, desktop apps, mobile clients, custom functions or specific subscription tiers.

References for these qualified claims: Zoho Sheet file formats and Zoho Sheet preferences and locale, both retrieved 2026-10-13.

• Authoritative function reference: Zoho Sheet COMPLEX help; checked 2026-10-13. This source supports the documented purpose, exact argument order, syntax, named error categories and the explicitly cited vendor examples. It does not supply a function-introduction date.
• Supporting vendor references: Zoho Sheet complex-function catalogue, locale preferences, and supported file formats; checked 2026-10-13. These support related-function names and qualified platform/locale/import statements, not precise compatibility equivalence.
• Independent validation: Standard complex arithmetic in Python (built-in complex/abs) with manually derived checks. These independent calculations are not Zoho Sheet executions.
• Outstanding review: Native confirmation of formula parsing, cell formatting, import/export conversion, unusual string forms and any account/locale-specific behaviour.