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

The FTEST function calculates the value from an F-test. The value shows if the variances from two data sets are not significantly different.

This function is outdated and is replaced with the F.TEST which was introduced in Excel 2010.

Formula in cell D12:


Excel Function Syntax

FTEST(array1, array2)


array1 Required. The first data set.
array2 Required. The second data set.


The arguments must contain numbers or cell references to numbers.

Text, boolean and empty values are ignored.

The FTEST function returns

  • #DIV/0! error value if the number of items in each data set don't match.
  • #VALUE! error value if any argument is non-numeric.

The LINEST function calculates the F statistic whereas the FTEST function calculates the probability.