Seifeddine87
Board Regular
- Joined
- Sep 7, 2015
- Messages
- 128
- Office Version
- 2016
- 2011
- 2010
hi i have got multiple sizes of stock and i want to separate them in a different groups
for example
Group 1 (G1) will be less the 10-8-8 640
Group 2 (G2) bigger then G1 and less then 20-10-10 2000
Group 3 (G3) bigger then G2 and less then 40-30-10 12000
i want a formula that will compare L,W,H and dim to give me the right group number
<tbody>
</tbody>
for example
Group 1 (G1) will be less the 10-8-8 640
Group 2 (G2) bigger then G1 and less then 20-10-10 2000
Group 3 (G3) bigger then G2 and less then 40-30-10 12000
i want a formula that will compare L,W,H and dim to give me the right group number
A | B | C | D | E | F | G | H | I | |
1 | length | width | height | Dim | Group | ||||
2 | 10 | 8 | 8 | 640 | G1 | ||||
3 | 8 | 5 | 5 | 200 | G1 | ||||
4 | 20 | 10 | 10 | 2000 | G2 | ||||
5 | 15 | 10 | 5 | 750 | G2 | ||||
6 | 40 | 30 | 10 | 12000 | G3 | ||||
<tbody>
</tbody>