Dear All

I am aiming to classify Column E as 'Type' 1-7 on the basis of values in columns D and C. If values in D are <80 then I need to base the type (column E) on values in column C. So for example, if column D is <80 and column C is>=10, <50 then the type value in column E should be '2'. I have produced a formula for this which works OK:

=IF(D2<80,IF(C2<10,"1",IF(AND(C2>=10,C2<50),"2",IF(AND(C2>=50,C2<100),"3",IF(AND(C2>=100,C2<200),"5",IF(C2>=200,"7"))))))

I also need another formula for when column D is >80. A similar situation applied but with slightly different types in column E based on values in column C. I have produced this formula which works OK:

=IF(D2>80,IF(C2<10,"1",IF(AND(C2>=10,C2<50),"2",IF(AND(C2>=50,C2<100),"4",IF(AND(C2>=100,C2<200),"6",IF(C2>=200,"7"))))))


The problem is, these formulas work fine in separate columns but I cannot seem to join them into one large formula. I have tried to join them but I keep getting 'FALSE' when D values are >80. Basically it wont recognize the second half of the formula (D>80...) when joined. Ideally I would have one column for Type rather than 2 which I currently have.

If anyone can help here I would be most grateful.

AT0