Problem: Find the smallest value in a list but it has to be bigger than 10?


  1. MINIFS function [Excel 2016]
  2. MIN + IF functions [Excel 2013 and previous versions]

MINIFS function [Excel 2016]

Formula in cell C3:


MIN + IF functions [Array Formula]

Array formula in cell C12:


Explaining array formula

A1:A25 is the list of values, the same as an array.

IF(A1:A25>10,A1:A25,"") sorts out all values in the array above 10.

MIN(IF(A1:A25>10,A1:A25,"")) returns the smallest value in the array.

Returns the smallest value in a set of values, ignores logical values and text