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