[]

Document Solutions for Excel, Java Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
  - BETADIST
  - BETAINV
  - BINOMDIST
  - CHIDIST
  - CHIINV
  - CHITEST
  - CONFIDENCE
  - COVAR
  - CRITBINOM
  - EXPONDIST
  - FDIST
  - FINV
  - FLOOR
  - FTEST
  - GAMMADIST
  - GAMMAINV
  - HYPGEOMDIST
  - LOGINV
  - LOGNORMDIST
  - MODE
  - NEGBINOMDIST
  - NORM.INV
  - NORMDIST
  - NORMSDIST
  - NORMSINV
  - PERCENTILE
  - PERCENTRANK
  - POISSON
  - QUARTILE
  - RANK
  - STDEV
  - STDEVP
  - TDIST
  - TINV
  - TTEST
  - VAR
  - VARP
  - WEIBULL
  - ZTEST
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Use JDK 8 Date Time API
Document Solutions Data Viewer
API Reference
Release Notes

FINV

This function returns the inverse of the F probability distribution.

Syntax

FINV(p, degnum, degden)

Arguments

This function has these arguments:

Argument	Description
p	[Required] Probability associated with the F cumulative distribution
degnum	[Required] Number of degrees of freedom for the numerator; if not an integer, the number is truncated
degden	[Required] Number of degrees of freedom for the denominator; if not an integer, the number is truncated

If either degnum or degden is not an integer, it is truncated.

Remarks

This function calculates the inverse of the F probability distribution, so if p = FDIST(x,...), then FINV(p,...) = x.

Examples

FINV(A1,2,2)

FINV(R1C1,2,1)

FINV(0.021,5,3) gives the result 16.83979