Quick Navigation

F.INV.RT Function

Q: What does F.INV.RT calculate?

It finds the x value where F.DIST.RT(x, df1, df2) equals the specified probability - the inverse right-tailed F distribution.

Q: When should I use F.INV.RT vs F.INV?

Use F.INV.RT for right-tailed tests (most common). F.INV is for left-tailed distributions.

Q: Why do I get #NUM! error?

Check that probability is between 0-1, df1 ≥ 1, df2 ≥ 1 and df2 < 10^10.

Excel 2010+

Summary

The F.INV.RT function returns the inverse of the right-tailed F probability distribution, enabling precise calculation of critical F-values for statistical analysis and hypothesis testing.

Syntax

F.INV.RT(probability, deg_freedom1, deg_freedom2)

Parameters

Parameter	Type	Required	Description
probability	`Number`	Yes	Right-tail probability (0 < probability < 1) for F cumulative distribution
deg_freedom1	`Number`	Yes	Numerator degrees of freedom - integer value ≥ 1
deg_freedom2	`Number`	Yes	Denominator degrees of freedom - integer value ≥ 1 and < 10^10

Using the F.INV.RT Function

F.INV.RT is crucial for statistical analysis, particularly when performing F-tests to compare variances between two populations or determining critical values for ANOVA tables. If p = F.DIST.RT(x,...), then F.INV.RT(p,...) = x, making it the perfect inverse function pair.

Common F.INV.RT Examples

Calculate F Critical Value for 1% Significance

=F.INV.RT(0.01, 6, 4)

Returns 15.20686 - the F critical value for α=0.01 with 6 numerator and 4 denominator degrees of freedom.

ANOVA Critical Value Lookup

=F.INV.RT(0.05, B2, C2)

Returns 5% significance critical F-value using degrees of freedom from cells B2 and C2.

Variance Test Critical Value

=F.INV.RT(A1, 10, 15)

Calculates critical F-value for probability in A1 with specified degrees of freedom.

Frequently Asked Questions

It finds the x value where F.DIST.RT(x, df1, df2) equals the specified probability - the inverse right-tailed F distribution.

Use F.INV.RT for right-tailed tests (most common). F.INV is for left-tailed distributions.

Check that probability is between 0-1, df1 ≥ 1, df2 ≥ 1 and df2 < 10^10.

Common Errors and Solutions

#VALUE!

Cause: Non-numeric arguments provided

Solution: Ensure all inputs are valid numbers

#NUM!

Cause: Probability < 0 or > 1, or invalid degrees of freedom

Solution: Verify 0 < probability < 1, df1 ≥ 1, 1 ≤ df2 < 10^10

#N/A

Cause: Iterative algorithm failed to converge after 64 iterations

Solution: Check input precision and try slightly different probability values

Notes

Non-integer degrees of freedom are truncated to integers
Maximum df2 limit is 10^10 - very large values may cause precision issues
Perfect companion to F.DIST.RT for complete F-distribution analysis
Available only in Excel 2010 and later versions

Compatibility

Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365

Not available in: Excel 2007, Excel 2003, Earlier versions

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+