MIN + IF (array formula) Function in Excel: Syntax, Examples and Free Practice
MIN + IF (array formula) is an Excel Math & Trig function. An array-entered formula that finds the lowest value only among rows matching a condition (a conditional MIN).
MIN + IF (array formula) syntax
Arguments
criteria_range: Range to testcriteria: Value to matchvalue_range: Range to find the min within
When to use MIN + IF (array formula)
Finding the fastest delivery time specifically among Express orders.
Practice MIN + IF (array formula) online, free
Open the live Excel-style spreadsheet and try MIN + IF (array formula) yourself. No Excel install or sign-up needed to start.
Practice MIN + IF (array formula) now →More Math & Trig functions
Frequently asked questions
What does the MIN + IF (array formula) function do in Excel?
An array-entered formula that finds the lowest value only among rows matching a condition (a conditional MIN).
What is the syntax of MIN + IF (array formula) in Excel?
The syntax is =MIN(IF(criteria_range=criteria, value_range)). criteria_range: Range to test; criteria: Value to match; value_range: Range to find the min within.
Where can I practice MIN + IF (array formula) online for free?
Open the free live spreadsheet on Cellgrids and try MIN + IF (array formula) yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts