Test F Excel. Sometimes you need to check if a cell is blank generally because you might not want a formula to display a result without input. F test is a statistical tool in excel which is used to hypothesis test with the help of variance of 2 datasets or population.
Click in the variable 1 range box and select the range a2 a7. The if function is used to run a logical test and react differently depending on whether the result is true or false. Note that f test function does not returns the f test value instead it returns it s probability.
The first argument logical test is an expression that returns either true or false both value if true and value if false are optional but at least one of them must be provided.
In this case we re using if with the isblank function. This can be sure when the variance of both the data sets are equal. Here is the formula to check the list in range d2 d5 and check in cell a2 and return value in b2. Those who use excel daily are well versed with excel if statement as it is one of the most used formula.
