Finding a Maximum Value with a Condition ("MaxIF")

Very similar to last post. the "MinIf" function, if you want to get the maximum value with a condition then use this formula!

Assume data is in A1:A5 and want to get the maximum value BELOW 12,000, then.

=Max((if(A1:A5<12000,a1:a5,false))

Again, use CTL-SHIFT-ENTER to convert into an array formula and your done!

Tweet