Array function not working correctly if I use an "or - statement"
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
|