# BETA.INV

## Content

This function calculates the inverse of the cumulative beta density function.

## Syntax

`BETA.INV(prob, alpha, beta, [lower], [upper])`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *prob* | [Required] Probability of the distribution |
| *alpha* | [Required] Alpha parameter of the distribution |
| *beta* | [Required] Beta parameter of the distribution |
| *lower* | [Optional] Lower bound of the interval for x; 0 if omitted |
| *upper* | [Optional] Upper bound of the interval for x; 1 if omitted |

## Remarks

If you omit values for *upper* and *lower*, the calculation uses the standard cumulative beta distribution, so that *lower* is zero and *upper* is one. This function returns the #VALUE! error value if any argument is non-numeric.

## Examples

`BETA.INV(0.75,B3,C3,2,4)`
`BETA.INV(0.75,R3C2,R3C3,2,4)`