The best way to understand how to combine the MIN and IF functions in Excel is with an example. This sample tutorial contains heat times for two events from a track meet – the 100 and 200 meter sprints, and applies to Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.
| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 | Publish Date not found |  0 Views |
Excel Array Formulas Explained Using MIN and IF Functions (Part 1 of 5)
Using a MIN IF array formula, you can find the fastest heat time for each race with a formula.
The job for each part of the formula is as follows:
The syntax for the MIN IF formula is:
