<div class="raw-html-embed">    <p>The <b>BINOM.DIST.RANGE</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 return the probability of a trial result using a binomial distribution.</p>

    <h5 class="pt8">Syntax</h5>
    <p><b><em>BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])</em></b></p>
    <p>The <b>BINOM.DIST.RANGE</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>trials</em></b></td>
                <td>The number of trials, a numeric value greater than or equal to <b><em>number_s</em></b>.</td>
            </tr>
            <tr>
                <td><b><em>probability</em></b></td>
                <td>The success probability of each trial, a numeric value greater than or equal to 0 but less than or equal to 1.</td>
            </tr>
            <tr>
                <td><b><em>number_s</em></b></td>
                <td>The minimum number of successes in the trials you want to calculate probability for, a numeric value greater than or equal to 0.</td>
            </tr>
            <tr>
                <td><b><em>number_s2</em></b></td>
                <td>An optional argument. The maximum number of successes in the trials you want to calculate probability for, a numeric value greater than <b><em>number_s</em></b> and less than or equal to <b><em>trials</em></b>.</td>
            </tr>
        </tbody>
    </table>

    <h5 class="pt8">Notes</h5>
    <p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>BINOM.DIST.RANGE</b> function.</p>

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

BINOM.DIST.RANGE Function

Docs

Argument	Description
*trials*	The number of trials, a numeric value greater than or equal to *number_s*.
*probability*	The success probability of each trial, a numeric value greater than or equal to 0 but less than or equal to 1.
*number_s*	The minimum number of successes in the trials you want to calculate probability for, a numeric value greater than or equal to 0.
*number_s2*	An optional argument. The maximum number of successes in the trials you want to calculate probability for, a numeric value greater than *number_s* and less than or equal to *trials*.

BINOM.DIST.RANGE Function

Syntax

Notes

Examples

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