<div class="raw-html-embed">	The PROB 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 that values in a range are between lower and upper limits.

	<h5 class="pt8">Syntax</h5>
	PROB(x_range, prob_range, [lower_limit], [upper_limit])
	The PROB function has the following arguments:
	<table style="width: 40%">
		<tbody>
			<tr>
				<th style="background-color: #f4f4f4" width="150ch">Argument</th>
				<th style="background-color: #f4f4f4">Description</th>
			</tr>
			<tr>
				<td>x_range</td>
				<td>The selected range of cells containing numeric values you want to associate the probabilities with.</td>
			</tr>
			<tr>
				<td>prob_range</td>
				<td>A set of probabilities associated with values in x_range, the selected range of cells containing numeric values greater than 0 but less than 1. The sum of the values in prob_range should be equal to 1, otherwise the function will return the #NUM! error.</td>
			</tr>
			<tr>
				<td>lower_limit</td>
				<td>The lower bound of the value, a numeric value entered manually or included into the cell you make reference to.</td>
			</tr>
			<tr>
				<td>upper_limit</td>
				<td>The upper bound of the value, a numeric value entered manually or included into the cell you make reference to. It is an optional argument. If it is omitted, the function will return the probability equal to lower_limit.</td>
			</tr>
		</tbody>
	</table>

	<h5 class="pt8">Notes</h5>
	x_range should contain the same number of elements as prob_range.
	<a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the PROB function.

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

PROB Function

Docs

Argument	Description
*x_range*	The selected range of cells containing numeric values you want to associate the probabilities with.
*prob_range*	A set of probabilities associated with values in *x_range, the selected range of cells containing numeric values greater than 0 but less than 1. The sum of the values in prob_range* should be equal to 1, otherwise the function will return the #NUM! error.
*lower_limit*	The lower bound of the value, a numeric value entered manually or included into the cell you make reference to.
*upper_limit*	The upper bound of the value, a numeric value entered manually or included into the cell you make reference to. It is an optional argument. If it is omitted, the function will return the probability equal to *lower_limit*.

PROB Function

Syntax

Notes

Examples

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