Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 50 | <100 | ||||
2 | 100 | >100<300 | ||||
3 | 200 | >100<300 | ||||
4 | 350 | >300<500 | ||||
5 | 520 | >500<1000 | ||||
6 | 900 | >500<1000 | ||||
7 | 1120 | >1000<7500 | ||||
8 | 1500 | >1000<7500 | ||||
9 | 7000 | >1000<7500 | ||||
10 | 8000 | >7500 | ||||
Sheet1 |
=if(and(H733>100),(H733<300)),"Between 100 & 300",next test...)
=if((H733>100)*(H733<300),"Between 100 & 300",next test...)
=if(H733 < 100,"Small Value",if(H733 < 300, "Between 100 & 300",If(H773 < 500,"Between 300 & 500",If(H733 < 7500, etc .... ))))