1. Computing
Ted French

Excel MIN IF Array Formula

By January 1, 2013

Follow me on:

Excel MIN IF Array Formula
Excel MIN IF Array Formula
Ted French

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

Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.