Similar to the previously mentioned Excel MAX IF array formula is the *MIN IF array formula*.

The one difference of course is that it uses the MIN function to find the smallest value in a given list of data.

The IF function is used to set conditions so that you can control what data is used by a formula, and the array formula lets you carry out multiple calculations in a single cell.

To find out all the details, read this tutorial on the **Excel MIN IF Array Formula**.

**Related Tutorials**