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

Answer:

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

MINIFS function [Excel 2016]

Formula in cell C3:

=MINIFS(D4:D11,D4:D11,">10")

MIN + IF functions [Array Formula]

Array formula in cell C12:

=MIN(IF(A1:A25>10,A1:A25))

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.

MIN(number1,[number2],...)
Returns the smallest value in a set of values, ignores logical values and text