Statistical

PROB Function in Excel

Returns the probability that values in a range are between two limits.

Syntax

  • =PROB(x_range, prob_range, lower_limit, [upper_limit])

Arguments

  • x_range (required): Range of values
  • prob_range (required): Associated probabilities
  • lower_limit (required): Lower bound
  • upper_limit (optional): Upper bound (default = lower)

Examples

  • =PROB(A1:A4, B1:B4, 1, 3) - Probability between 1 and 3 - Result: Probability

PROB for data analysis

  • Confirm whether you need entire columns, filtered subsets, or distinct values.
  • Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
  • Pivot tables complement single-cell statistical formulas for exploration.

Common errors

  • Probabilities must sum to 1

Use cases

  • Discrete probability
  • Risk analysis
  • Decision making

Frequently asked questions

  • What is the PROB function in Excel? PROB returns the probability that values in a range are between two limits. The syntax is =PROB(x_range, prob_range, lower_limit, [upper_limit]). Typical use cases include discrete probability, risk analysis, decision making.
  • How do I use the PROB function? To use PROB, type =PROB( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • What type of data does PROB work with? PROB works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
  • Why is PROB not working in my Excel? Common issues with PROB include Probabilities must sum to 1. Start by checking the syntax =PROB(x_range, prob_range, lower_limit, [upper_limit]), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.