FINV function
FINV returns the critical F value for a right-tail probability, for a chosen significance level. It still works, but F.INV.RT supersedes it, so use that in new workbooks.
Example
Read it as a sentence: find the F value that leaves a 5% right-tail probability with 2 and 10 degrees of freedom, which gives 4.102821015.
A
B
C
D
1
4.102821015
2
3
Syntax
FINV(probability, deg_freedom1, deg_freedom2)
-
probability(required) - Right-tail probability.
-
deg_freedom1(required) - Numerator degrees of freedom.
-
deg_freedom2(required) - Denominator degrees of freedom.
Returns: The F value with the given right-tail probability.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=FINV(0.05,2,10) | 4.102821015 | Working example |
=FINV("0.05",2,10) | 4.102821015 | Text-number in first arg |
=FINV({0.05,0.05},2,10) | 4.102821015 | Array in first arg (lifts, spills) |
=FINV(1,2,10) | 0 | Probability 1 |
=FINV("abc",2,10) | #VALUE! | Non-numeric text in first arg |
=FINV(NA(),2,10) | #N/A | Error in first arg |
=FINV(0,2,10) | #NUM! | Probability 0 |
=FINV(Data!D1,2,10) | #NUM! | Blank cell as first arg |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Superseded by F.INV.RT; use that in new workbooks.
- Solved iteratively; extreme inputs can return #N/A.
Where it works
- Excel
- FINV is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .