If cell contains

[Closed]
Report
-
Hello sir,
Actually I wanted to know is there any formula if column contain description like
- qty box size
1kg - 1200 =1200/12
500gm - 600 =600/24
200gm - 144 =144/72

i want the formula if cell contain 1kg the box size will automatically come in the next cell i.e. 100 box and 500gm corresspondent figure come to 25 box with the help of formula, as there are numbers of retailers who buy it.
we have a list D E S C R I P T I O N QTY. box size
a
1KG 2880 =2880/12
500GM 2064 =2064/24
200GM 360 =360/72
TOTAL : 4944
b
1KG 1416
500GM 744
TOTAL : 2160
c
1KG 16
500GM 32
TOTAL : 48
d
100GM 64
1KG 16
500GM 80
TOTAL : 160
e
100GM 2880
1KG 5080
200GM 5760
25GM 31680
500GM 8560
50GM 7200