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:

=BETA.INV(C3,C4,C5,C6,C7)

Excel Function Syntax

BETA.INV(probability,alpha,beta,[A],[B])

Arguments

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.

Comments

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