# Documentation/Calc Functions/BINOM.INV

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

BINOM.INV

## Category:

Statistical Analysis

## Summary:

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a border probability.

## Syntax:

BINOM.INV(**Trials**; **SP**; **Alpha**)

## Returns:

Returns a real number.

## Arguments:

**Trials** is a positive integer value or a reference to a cell containing that value which is the total number of trials.

**SP** is a real number between 0 and 1(both inclusive) or a reference to a cell containing that number is the probability of success on each trial.

**Alpha** is a real number between 0 and 1(both inclusive) or a reference to a cell containing that number which is the border probability that is attained or exceeded.

- If
**Trials**is a non-integer value, then the function truncates it to an integer. - If
**Trials**is less than zero, then the function returns an error value. - If
**SP**or**Alpha**are greater than 1 or less than 0, then the function returns an error value.

## Additional details:

- For more details th on inverse binomial distribution, visit
**Wikipedia**. - CRITBINOM and BINOM.INV performs the same function

## Examples:

Formula | Description | Returns |
---|---|---|

=BINOM.INV(8;0.6;0.9) | the smallest value for which the cumulative binomial distribution is greater than or equal to 0.9. | 7 |

## Related LibreOffice functions:

## ODF standard:

None

## Equivalent Excel functions:

BINOM.INV