<div class="raw-html-embed">    <p>The <b>COMPLEX</b> function is one of the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#engineering" onclick="onhyperlinkclick(this)">engineering functions</a>. It is used to convert a real part and an imaginary part into the complex number expressed in a + bi or a + bj form.</p>

    <h5 class="pt8">Syntax</h5>
    <p><b><em>COMPLEX(real_num, i_num, [suffix])</em></b></p>
    <p>The <b>COMPLEX</b> function has the following arguments:</p>
    <table style="width: 40%">
        <tbody>
            <tr>
                <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                <th style="background-color: #f4f4f4"><b>Description</b></th>
            </tr>
            <tr>
                <td><b><em>real_num</em></b></td>
                <td>The real part of the complex number.</td>
            </tr>
            <tr>
                <td><b><em>i_num</em></b></td>
                <td>The imaginary part of the complex number.</td>
            </tr>
            <tr>
                <td><b><em>suffix</em></b></td>
                <td>An indicator of the imaginary part of the complex number. It can be either "i" or "j" in lowercase. It is an optional argument. If it is omitted, the function will assume <b><em>suffix</em></b> to be "i".</td>
            </tr>
        </tbody>
    </table>

    <h5 class="pt8">Notes</h5>
    <p><a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>COMPLEX</b> function.</p>

    <h5 class="pt8">Examples</h5>
    <p>The figure below displays the result returned by the <b>COMPLEX</b> function.</p>
    <p><img alt="COMPLEX Function" src="https://static-helpcenter.teamlab.info/complex_8f967d02bb.png"></p></div>

COMPLEX Function

Docs

Argument	Description
*real_num*	The real part of the complex number.
*i_num*	The imaginary part of the complex number.
*suffix*	An indicator of the imaginary part of the complex number. It can be either "i" or "j" in lowercase. It is an optional argument. If it is omitted, the function will assume *suffix* to be "i".

COMPLEX Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud