Author: Oscar Cronquist Article last updated on October 12, 2018

The F.DIST function calculates the F probability for two tests. This function was introduced in Excel 2010 and has replaced the FDIST function.

Formula in cell C7:


Excel Function Syntax

F.DIST(x, deg_freedom1, deg_freedom2, cumulative)


x Required.
deg_freedom1 Required. Degrees of freedom (numerator).
deg_freedom2 Required. Degrees of freedom (denominator).
cumulative Required. A boolean value.
TRUE - Cumulative distribution function.
FALSE - Probability density function.


The F.DIST function returns

  • #VALUE! error value if any argument is non-numeric.
  • #NUM! error value if:
    • x < 0 (zero)
    • deg_freedom1 < 1
    • deg_freedom2 < 1

deg_freedom1 and deg_freedom2 will be converted into integers if they are not.