Hi All
I need a formula for weight calculation, first table shows weight type and their different rate and second table is weight calculation where I require formula in cost column as per first per first table weight rate.
Thanks in advance
Sheet1
I need a formula for weight calculation, first table shows weight type and their different rate and second table is weight calculation where I require formula in cost column as per first per first table weight rate.
Thanks in advance
Sheet1
A | B | C | D | E | F | |
2 | Weight (Kg) | Rate - A | Rate - B | Rate - C | ||
3 | 0.1 to 0.5 | 12 | 20 | 25 | ||
4 | 0.6 to 1.4 | 14 | 22 | 27 | ||
5 | Each additional Kg | 10 | 18 | 23 | ||
6 | ||||||
7 | ||||||
8 | Required Formula in this col |