would be a lot easier to simply enter:
A B
0 <3
3 3-5
6 6-10
11 11-15
16 16-20
21 20

in a table, then you only need to do =VLOOKUP(E2,A:B,2)

"KS" wrote:

Hey all,
Hope your day is going better then mine. :)

Getting right to the point...

Here is the formula that goes in column G
=IF(E2<3,"<3",IF(OR(E2=3,E2<=5),"3-5",IF(OR(E2=6,E2<=10),"6-10",IF(OR(E2=11,E2<=15),"11-15",IF(OR(E2=16,E2<=20),"16-20","20")))))

data out of column E
11
15
3
20
-2

actual output of column G from formula
3-5
3-5
3-5
3-5
<3

output that SHOULD be coming into column G
11-15
11-15
3-5
16-20
<3

What is wrong with the formula? Why is it only looking at the first 2 Ifs?
Hope this makes sense, if you have any questions let me know. Any help would
be great. Thanks in advance!