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 | |||||

9 | Item Dn | Rate Type | Weight - Kg | Cost | ||

10 | 2021 | A | 0.3 | 12 | ||

11 | 2022 | A | 1.2 | 14 | ||

12 | 2023 | B | 0.5 | 20 | ||

13 | 2024 | B | 2 | 24 | ||

14 | 2025 | B | 2.4 | 24 | ||

15 | 2026 | C | 4 | 96 | ||

16 | 2027 | C | 1.4 | 27 |

<colgroup><col style="width: 30px;"><col style="width: 121px;"><col style="width: 68px;"><col style="width: 78px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>

</tbody>

**Excel tables to the web >>**Excel Jeanie HTML 4