# BETAINV

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



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

## Syntax

BETAINV(*prob*,*alpha*,*beta*,*lower*,*upper*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *prob* | Probability of the distribution |
| *alpha* | Alpha parameter of the distribution |
| *beta* | 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.

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

`BETAINV(0.75,B3,C3,2,4)`
`BETAINV(0.75,R3C2,R3C3,2,4)`
`BETAINV(0.75,9,12,2,4)` gives the result 3.0011968805

## Version Available

This function is available in product version 1.0 or later.

## See Also

[BETADIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionBETADIST) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)