Hi,

I have two arrays which I want to use in order to create some
statistics. However, if I want EITHER of two things to hold true for
the array matching, then it breaks down (gives wrong value).

The following straightforward line works perfectly:

{=MIN(IF((NB1=$B$12),NB_LossAmount))}

However, this line (which should do the same) does not work:

{=MIN(IF(OR(NB1=$B$12),NB_LossAmount))}

Why is this discrepancy?

What I really want to do is the following...

{=MIN(IF(OR(NB1=$B$12,NB1=$B13),NB_LossAmount))}


I know I can multiply the two arrays together if I want to check that
NB_LossAmount for the ones where NB1 equals both B12 and B13, but this
is not what I want. I want to have it so that if NB1 equals EITHER B12
or B13, then take the value from NB_LossAmount..

Any suggestions greatly appreciated

Best regards,

Peder Wessel