MIN with 3 IF conditions

[thecursero]

Can you please help me to add one more if condition to this formula:

=MIN(IF($J$3:$J$142=B159;IF($H$3:$H$142=D159;$L$3:$L$142)))

Thank you

 

[thecursero]

I just want to use the same conditions as in =AVERAGEIFS(R3:R192;F3:F192;G214;N3:N192;I214;P3:P192;H214)
but my xls doesn't have MINIFS or MAXIFS conditions so I have to use =MIN(IF($J$3:$J$142=B159;IF($H$3:$H$142=D159;$L$3:$L$142))) but please help me to add one more condition in this formula...
big thanks !

 

[AhoyNC]

Would be something like this:

=MIN(IF($J$3:$J$142=B159;IF($H$3:$H$142=D159;IF(Condition to add;$L$3:$L$142))))

<colgroup><col width="591"></colgroup><tbody>
</tbody>

 

[krrishkrsna]

i think you have to use "," instead of ";"
Min(If(condition,if(condition,if(condition,result))))
press ctrl+shift+enter

 

[AhoyNC]

@krrishkrsna
Since OP was using ";" in the formula they posted, I assume that the language setting on there Excel is set to use ";" and not "," between arguments.

 

[63falcondude]

Personally, I write MIN IF functions like this:

=MIN(IF((condition1)*(condition2)*(condition3),result)) Ctrl Shift Enter

Just swap the comma for a semicolon if your regional settings use ";" instead of ",".