<div class="raw-html-embed">    <p>The <b>LOGEST</b> function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#statistical" onclick="onhyperlinkclick(this)">statistical functions</a>. It is used to calculate an exponential curve that fits the data and returns an array of values that describes the curve.</p>

    <h5 class="pt8">Syntax</h5>
    <p><b><em>LOGEST(known_y’s, [known_x’s], [const], [stats])</em></b></p>
    <p>The <b>LOGEST</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>known_y’s</em></b></td>
                <td>The set of y-values you already know in the <em>y = b*m^x</em> equation.</td>
            </tr>
            <tr>
                <td><b><em>known_x’s</em></b></td>
                <td>The optional set of x-values you might know in the <em>y = b*m^x</em> equation.</td>
            </tr>
            <tr>
                <td><b><em>const</em></b></td>
                <td>An optional argument. It is a TRUE or FALSE value where TRUE or lack of the argument forces <em>b</em> to be calculated normally and FALSE sets <em>b</em> to 1 in the <em>y = b*m^x</em> equation and m-values correspond with the <em>y = m^x</em> equation.</td>
            </tr>

            <tr>
                <td><b><em>stats</em></b></td>
                <td>An optional argument. It is a TRUE or FALSE value that sets whether additional regression statistics should be returned.</td>
            </tr>
        </tbody>
    </table>

    <h5 class="pt8">Notes</h5>
    <p>Please note that this is an array formula. To learn more, please read the <a href="../../docs/userguides/spreadsheet_editor/InsertArrayFormulas.aspx" onclick="onhyperlinkclick(this)">Insert array formulas</a> article.</p>
    <p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>LOGEST</b> function.</p>

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

LOGEST Function

Docs

Argument	Description
*known_y’s*	The set of y-values you already know in the y = bm^x* equation.
*known_x’s*	The optional set of x-values you might know in the y = bm^x* equation.
*const*	An optional argument. It is a TRUE or FALSE value where TRUE or lack of the argument forces b to be calculated normally and FALSE sets b to 1 in the y = bm^x* equation and m-values correspond with the y = m^x equation.
*stats*	An optional argument. It is a TRUE or FALSE value that sets whether additional regression statistics should be returned.

LOGEST Function

Syntax

Notes

Examples

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