F.INV.RT Function
Returns the inverse of the right-tailed F distribution — the critical F value.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
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.RT returns the F value with the given probability above it: the critical value an F statistic must beat to be significant.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| probability | Yes | The right-tail probability (significance level), 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 — Critical F at the 5% level
5 and 10 degrees of freedom.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | F statistic | 3.2 |
| 3 | df1 | 5 |
| 4 | df2 | 10 |
| 5 | Critical (5%) | 3.3258 |
The statistic (3.2) falls just short of the critical value (3.33), matching the p-value of 0.055.
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.