ExcelFlux

FINV function

the inverse of the F probability distribution.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Recover an F cutoff from an upper-tail probability.

A worked example from the workbook

RowA
6Input
70.1
80.5
90.9
Record 1
=FINV(A7,4,8)

Illustrative output2.806425706

See the inputs and instructions for all 3 examples

Compatibility function for older workbooks.

Worked examples

Recover an F cutoff from an upper-tail probability.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 0.1
8 0.5
9 0.9
Trial Expression Sample output
Record 1 =FINV(A7,4,8) 2.806425706
Record 2 =FINV(A8,4,8) 0.914645356
Record 3 =FINV(A9,4,8) 0.2528483401
Microsoft Excel reference