Author: Oscar Cronquist Article last updated on September 24, 2018

The BETA.INV function calculates the inverse of the cumulative beta distribution. This function has replaced the BETA.INV function and was introduced in Excel 2010.

Formula in cell C9:


Excel Function Syntax



probability Required.
alpha Required. A distribution parameter.
beta Required. A distribution parameter.
[A] Optional. Lower bound, default value 0 (zero).
[B] Optional. Upper bound, default value 1.


The BETAINV function returns

  • #VALUE! error value if any argument is non-numeric.
  • #NUM! error value if:
    • alpha <= 0 (zero)
    • beta <= 0 (zero)
    • probability <= 0 (zero)
    • probability > 1
    • A = B