Hi, I have tried different IF and LOOKUP functions without success. I have many values sorted vertical in two columns (W and L) and would like to get an category presented based on these two values

W | L | cat
---------------
3.0 | 2.0 | ?
2.5 | 3.0 | ?
6.0 | 0.5 | ?

I hope someone in here can help me to establish a formula that can determine a category based on these parameters:

Category 1: {[W ≥ 3] and [L ≥ 3]}

Category 2: {([1 ≤ W < 6] and [1 ≤ L < 6] and [0.5 < L/W < 2]) and not ([W ≥ 3] and [L≥ 3])}

Category 3: {[1 ≤ W < 3] and [L/W ≥ 2]}

Category 4: {[L/W ≤ 0.5] and [1 ≤ L < 3]}

Category 5: {[0 < W < 1] and [0 < L < 1}

Category 6: {[0 < W < 1] and [L ≥ 1]}

Category 7: {[W ≥ 1] and [0 < L < 1]}

So after filtered two values through these rules, a category will be determined