FINV Function in Excel: Syntax, Examples and Free Practice
FINV is an Excel Compatibility function. Legacy inverse F distribution — kept for compatibility with older files.
FINV syntax
Arguments
probability: The probability value to evaluatedeg_freedom1: The degrees of freedom for the numeratordeg_freedom2: The degrees of freedom for the denominator
When to use FINV
FINV is kept mainly for opening older files built in earlier versions of Excel.
Practice FINV online, free
Open the live Excel-style spreadsheet and try FINV yourself. No Excel install or sign-up needed to start.
Practice FINV now →More Compatibility functions
- BETADIST
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- COVAR
- CRITBINOM
- EXPONDIST
- FDIST
- FTEST
- GAMMADIST
- GAMMAINV
- HYPGEOMDIST
Frequently asked questions
What does the FINV function do in Excel?
Legacy inverse F distribution — kept for compatibility with older files.
What is the syntax of FINV in Excel?
The syntax is =FINV(probability, deg_freedom1, deg_freedom2). probability: The probability value to evaluate; deg_freedom1: The degrees of freedom for the numerator; deg_freedom2: The degrees of freedom for the denominator.
Where can I practice FINV online for free?
Open the free live spreadsheet on Cellgrids and try FINV yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Compatibility functions · Excel case studies · Excel tutorials · Excel shortcuts