F.INV Function
Returns the inverse of the left-tailed F distribution.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Want to practice F.INV in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
The F distribution describes the ratio of two variances. It's used to test whether two groups vary by different amounts and in ANOVA and regression. It has two degrees of freedom: one for the top of the ratio, one for the bottom.
F.INV returns the F value with the given probability below it.
Syntax
=F.INV(probability, deg_freedom1, deg_freedom2) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| probability | Yes | The left-tail probability, from 0 to 1. |
| deg_freedom1 | Yes | Degrees of freedom of the numerator (top). |
| deg_freedom2 | Yes | Degrees of freedom of the denominator (bottom). |
Examples
Example 1 — The 95th percentile
5 and 10 degrees of freedom.
B4fx=F.INV(0.95,B2,B3)
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | df1 | 5 |
| 3 | df2 | 10 |
| 4 | 95% below | 3.3258 |
=F.INV(0.95,B2,B3) Explain
The same as F.INV.RT(0.05,5,10).
Common mistakes
- #NUM! probability is outside 0–1, or either degrees of freedom is less than 1.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.