"Joel" wrote in message
...
You code look correct. I tried it on Excel 2003.

You did? I would suggest that your test data must have been highly dubious
then because ORing two conditions like that will return a singleton TRUE if
any row matches, or a singleton FALSE if none do. If it does resolve to
TRUE, the IF returns EVERY value in NB_LossAmount, and the MIN will only
return the (dubiously) correct answer if the minimum value of all values
happens to meet that set of conditions. If the minimum is in a row that
doesn't meet it, it will return that value.

To spell it out

NB1: X,X,X,X,Z,Y,Y,Z,Y,X
NB_LossAmount: 36,36,27,55, 8,41,29,5,72,61

If B12 = X and B13 = Y the minimum value that meets either condition is 27.
Your formula will return 5, the minimum value regardless because of the fact
that it build an array of all values, not just those that meet the criteria.