F.INV Function in Excel: F Value for a Left-Tail Probability

F.INV Function in Excel: F Value for a Left-Tail Probability 1
⏱ 1 min readUpdated 5 October 2026

StatisticsLevel: ExpertAvailable in: Excel 2010+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. F.INV in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

F.INV returns the F value for a left-tail probability.

Advertisement

Syntax

=F.INV(probability, deg_freedom1, deg_freedom2)
Argument What it means
probability 0..1
df1, df2 df

Examples

Example 1

=ROUND(F.INV(A2,B2,C2),3)

Result: 0.115. See the worked example table below for more cases.

F.INV in practice

Where you will use it

  • Lower critical values
  • Teaching
  • Two-sided variance tests

Worked example

pdf1df2FormulaResult
0.05320=ROUND(F.INV(A2,B2,C2),3)0.115
0.5320=ROUND(F.INV(A3,B3,C3),3)0.816
0.95320=ROUND(F.INV(A4,B4,C4),3)3.098

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Wanting the usual critical valueUse F.INV.RT
p outside 0..1#NUM!

F.INV.RT

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZRSQ Function in Excel: How Well a Line FitsExcel Functions A–ZPERCENTRANK Function in Excel: Percentile Rank (Older Name)Excel Functions A–ZPOISSON Function in Excel: Poisson Probability (Older Name)
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong