IMDIV in Zoho Sheet: Divide Complex Numbers Safely

=IMDIV(complex_num1; complex_num2)

Both arguments are required; Zoho documents no optional parameters and no implicit divisor. The reference gives direct strings and a cell-based example, and describes arguments as text representing complex numbers. It does not explicitly guarantee a multi-cell array accepted in either position. Use one complex value per operand unless native range behaviour has been tested.

For z1=a+bj and nonzero z2=c+dj, the mathematical quotient is:

z1/z2 = [(ac+bd) + (bc−ad)j] / (c²+d²)

That formula multiplies numerator and denominator by the conjugate of the denominator. In Zoho’s example, a=2, b=3, c=1, d=2. The real coefficient is (2×1+3×2)/(1²+2²)=8/5=1.6; the imaginary coefficient is (3×1−2×2)/5=−1/5=−0.2. Thus the documented 1.6-0.2j follows from independently checked arithmetic. The denominator c²+d² is 5, not zero.

After creating C2:C6 as shown in the common practice table, enter formulas in D1:D6:

For D3, (2+3j)/(3−2j) has numerator after conjugate multiplication (2+3j)(3+2j)=0+13j and denominator 3²+(-2)²=13; therefore the quotient is j. For D4, reversing the first official example gives (1+2j)/(2+3j)=(8+j)/13, approximately 0.6153846154+0.0769230769j. The output may use more or fewer displayed digits depending on the sheet’s number and complex formatting; native rounding behaviour has not been measured.

1. Signal transfer ratio. If an input signal phasor is 1+2j and output is 2+3j, =IMDIV("2+3j";"1+2j") has transfer ratio 1.6-0.2j. The magnitude of that ratio is mathematically sqrt(1.6²+(-0.2)²)=sqrt(2.6)≈1.61245155. To check in a sheet, propose =IMABS(IMDIV(C2;C3)). Separate mathematical intent from any real circuit’s physical constraints.

2. Recover a previous value. If result = IMDIV(z1;z2) and z2 is nonzero, then IMPRODUCT(result;z2) should reproduce z1 mathematically. An audit formula is =IMPRODUCT(IMDIV(C2;C3);C3). Expected coefficients are real 2 and imaginary 3, subject to numerical rounding. This is an independent identity, not a verified Zoho engine property for all inputs.

3. Divide through conjugates. Use IMCONJUGATE for explaining why the denominator becomes real: (a+bj)/(c+dj)=((a+bj)(c−dj))/(c²+d²). The vendor help for IMCONJUGATE has a conflicting "1+4i" example, so use the mathematical identity for derivations but do not assume its i implementation until tested.

4. Batch auditing without array division. Add one formula per row rather than passing whole ranges: for example, if inputs are in C2:C4 and divisors in E2:E4, put =IMDIV(C2;E2) in F2, then copy through F4. Ensure each E-row is nonzero mathematically. The native result of =IMDIV(C2:C4;E2:E4) is not documented by the cited reference and is not recommended without a native test.

Mathematically, the quotient is undefined when the divisor equals zero (c=d=0). The official IMDIV error list does not specify the exact Zoho response for =IMDIV("2+3j";"0") or an equivalent zero complex string. This guide does not assert that a particular #DIV/0!, #VALUE!, or other error will appear. In a production model, validate the divisor’s coefficients or its magnitude before dividing; use native tests to establish a reliable guard. If a user types "0" instead of "0+0j", the parsing behaviour is a second unresolved variable, so design distinct tests for those two representations.

Avoid comparing approximate quotient text as an exact text string when recurring division introduces floating-point rounding. Compare IMREAL and IMAGINARY components to a numeric tolerance once those nested functions are tested. The official example for =IMDIV("6+5j";"5j") shows that purely imaginary divisors are valid in at least that documented case.

• Introduced: The original introduction version and date are not established by the checked sources.
• Availability: Currently documented in Zoho Sheet’s rolling web-service help; no numbered release or retirement endpoint is established.
• Scope: English-language web-service documentation. Mobile and offline-client parity is outside the verified scope.
• Checked: October 14, 2026, against the official IMDIV reference. Documentation check; not a new native test.

This guide was checked against Zoho Sheet’s official English-language cloud help on October 13, 2026. Formula separators here follow the vendor’s semicolon syntax (;); square brackets in syntax indicate optional arguments, not characters to type. The quoted i and j suffixes represent the mathematical imaginary unit and distinguish text-form complex numbers from ordinary spreadsheet numerics. For reproducibility, all exercises specify the cells and the input strings.

Zoho’s workbook locale settings let the author choose language, decimal separator, grouping, date and currency formats. The vendor’s English formulas are the directly checked source; changes in local decimal display or how formulas are entered under another locale have not been natively tested here. Zoho’s complex function catalogue includes this function, but the accessed reference does not establish a first-supported software version, a minimum subscription tier, or identical behaviour on iOS, Android, Windows and macOS clients. These particulars are unverified, not presumed universal.

Testing distinction: The vendor’s documentation supplies syntax and published examples. Expected outputs for additional examples were computed independently with standard complex arithmetic (Python complex values for QA), not by executing Zoho Sheet. Formatting of results, coercion of unusual inputs, mixed i/j suffixes, and edge-case error codes remain subject to an authenticated Zoho workbook test. No screenshot or account-level execution is claimed.

Reusable practice sheet

Create a blank Zoho Sheet and enter this input table into A1:C6 exactly. Alternatively import the complex-number practice CSV, starting at A1. Column C holds explicit text, not formulas. Do not paste formula results as replacements for the inputs.

Check that the imported C2:C6 values are literal strings. A formula such as =COMPLEX(2;3;"j") is an alternative documented way of generating the text 2+3j, but do not place it in C2 unless you intentionally want to test nested formulas. Other functions in the family include COMPLEX, IMREAL, IMAGINARY, and IMABS; those individual vendor pages were checked on October 13. A textual numeric value such as "2+3j" should not be treated as an ordinary numeric cell.

The official Zoho reference lists the following general spreadsheet error explanations; it does not promise that every error below occurs for every invalid argument to this specific function.

The function reference does not exhaustively document treatment of blanks, arrays beyond examples, text spacing, uppercase suffixes, combinations of i and j, overflow/underflow, or every malformed complex string. Do not advertise a specific result or error code for those cases without a native test. The display might simplify a coefficient of zero or one (for example 0+5j to 5j), so compare complex values—not merely strings—when validating a workbook. Zoho’s standard function-help error tables are not independent evidence that Excel and Zoho behave identically.

1. In a signed-in Zoho Sheet cloud workbook using the English help syntax, enter the listed official example and record displayed result, stored type, and application context.
2. Repeat with the supplied cell references; check that the content in C2:C6 is interpreted as text.
3. Compare independent mathematical expectations with the vendor example; preserve any disagreement, including separators, plus/minus signs and normalizing of a zero term.
4. Run separate edge-case probes for empty input, malformed string, alternative suffixes and invalid types. Record the actual returned error or value rather than guessing.
5. Optionally compare another locale or application platform, recording its locale, account tier and client version; do not backfill an invented first-release version.

Source descriptions below distinguish vendor statements from mathematical reasoning. The cited official documentation was reviewed on October 13, 2026; neither publication dates nor minimum versions were asserted by those pages.

• Definition, syntax, examples, general error list and related functions: Zoho Sheet IMDIV — checked 2026-10-13.
• Reusable source-cell construction: COMPLEX — checked 2026-10-13; the optional suffix defaults to lowercase i in the vendor example.
• Independent part/magnitude cross-checks: IMREAL, IMAGINARY, IMABS — checked 2026-10-13.
• Workbook display/locale choices: Zoho Sheet Locale and calculation settings — checked 2026-10-13.
• Function-category membership: Official Zoho Complex function index — checked 2026-10-13; the index contains 18 function titles, not a platform/version guarantee.

Official claim boundaries: The function reference directly supports the syntax, parameter descriptions and its own explicitly quoted example results. The other numerical examples, conjugate identities, transfer calculations and audit checks are mathematical predictions. Ambiguous i-suffix cases, zero handling, client/version/tier behaviour and output text normalization are not passed off as native test results.

• Build complex text with COMPLEX
• Extract the real coefficient with IMREAL
• Extract the imaginary coefficient with IMAGINARY
• Calculate magnitude with IMABS