F.TEST(array1, array2)

Returns the value from the f test.

array1The first array.
array2The second array.

Remarks

* Added in Excel 2010.
* This function replaces the FTEST function.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=F.TEST({1,2},{1,2}) = 1

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top