The Excel FINV function returns the inverse of the right-tailed F distribution — the F value for a given right-tail probability. It is the legacy name of F.INV.RT, introduced in Excel 2010.
Syntax
| Argument | Description | |
|---|---|---|
probability | Required | A right-tail probability associated with the F distribution (between 0 and 1). |
deg_freedom1 | Required | The numerator degrees of freedom (a positive integer). |
deg_freedom2 | Required | The denominator degrees of freedom (a positive integer). |
How to use it
FINV is the reverse of FDIST: give it a right-tail probability and the two degrees of freedom and it returns the F value (the critical value) that leaves that much area in the right tail.
This is the function that produces the critical values in an F table for an F-test or ANOVA. Because it works with the right tail, the modern replacement is F.INV.RT — not the left-tailed F.INV.
Use F.INV.RT instead: =F.INV.RT(0.01,6,4) in Excel 2010+ returns the same critical value. Watch the naming: F.INV (no .RT) inverts the left tail.
Try it: interactive demo
Pick a FINV example to see the formula and its result.
Practice workbook
Frequently asked questions
What is the modern replacement for FINV?
F.INV.RT, added in Excel 2010 — the inverse of the right-tailed F distribution. =F.INV.RT(0.01,6,4) equals =FINV(0.01,6,4).What does FINV calculate?
Is FINV the inverse of FDIST?
Why the right-tailed version?
F.INV.RT in modern workbooks; F.INV would return the left-tail value.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class