How to Combine the MIN and IF Functions in an Excel Array Formula

What Is a MIN IF Array?

The value_if_false argument is omitted since it is not needed and its absence shortens the formula.

Press theEnterkey on the keyboard to create the array formula.

Race Times data entered in Excel

The complete array formula appears in theformula barabove the worksheet.

Test the formula by finding the fastest time for the 200 meters.

Type200 metersinto cell D10 and press theEnterkey on the keyboard.

The formula should return the time of 21.49 seconds in cell E10.