F.DIST Function
Returns the left-tailed F distribution.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Want to practice F.DIST 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.DIST with cumulative TRUE returns the probability of an F value up to x. Test p-values usually use the right tail, F.DIST.RT.
Syntax
=F.DIST(x, deg_freedom1, deg_freedom2, cumulative) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The F value; can't be negative. |
| deg_freedom1 | Yes | Degrees of freedom of the numerator (top). |
| deg_freedom2 | Yes | Degrees of freedom of the denominator (bottom). |
| cumulative | Yes | TRUE for the cumulative (left-tail) probability, FALSE for the density. |
Examples
Example 1 — Left tail and density
An F value of 2 with 5 and 10 degrees of freedom.
B5fx=F.DIST(B2,B3,B4,TRUE)
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | F | 2 |
| 3 | df1 | 5 |
| 4 | df2 | 10 |
| 5 | Left tail | 0.8358 |
| 6 | Density | 0.1620 |
=F.DIST(B2,B3,B4,TRUE) Explain
Common mistakes
- #NUM! x is negative, 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.