H

#### Hjuler

I need to subtract numbers in a column (A2:A4) from the numbers in a row

(B22) in all possible combination, Find and return all values that match

certain intervals (F1,F2,F3,F4).

My array formula looks like this:

IF(OR(AND(B11-A2:A4>F1,B11-A2:A4<F2),AND(B11-A2:A4>F3,B11-A2:A4<F4)),B11-A2:A4,"-")

The problem is that the formula only returns "-" even though I know some of

the results are within the intervals (evaluates all the results as "not true"

even though I know they are true).

This is a simplyfied version of my work but it will illustrate my problem.

In reality I have more than 200 numbers in the row and the column and more

than 10 intervals...

I am working on a danish version of Excel so please tell me if I have

converted some symbols wrong