Menu
EXCEL PROB FUNCTION
Excel PROB Function Introduction
The Excel PROB function computes the probability associated with a particular range given a list of values and a matching list of probabilities.
Description of Excel PROB Function
Syntax :
=PROB( x_range, prob_range, [lower_limit], [upper_limit] )
Parameters :
- X range – A set of values with associated probability.
- Prob range – An array of chances matching to the x range values. (This arrays must be the same size as the x range array, as well as the prob range numbers must add up to one.)
- Lower limit – The lower limit of the range of possibilities whereby the probability is to be calculated.
- Upper limit – An optional number indicating the upper limits of the range for which you wish to compute the probability. (If the [upper limit] parameter is omitted, the function just returns the probability associated with the specified lower limit value.)
Step By Step Guide of PROB Function
Example :
Columns A and B of the spreadsheet below include a collection of values as well as the probabilities associated with them. In the spreadsheet’s cells C1-C3, these values and probabilities are sent to the Excel Prob functions.
Key Points
- #NUM! – Occurs if any of the following conditions are met: any value in the given prob range is 0 or more than one, or The specified prob range numbers do not add up to one.
- #N/A! – Occurs if the x range and prob range arrays given are of various lengths.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
