Weight Calculation Formula

[ayazgreat]

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

	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

 

[ayazgreat]

Shg yes you are right it is not two it will be two if weight is greater than 2.4 k g like 3 of

 

[shg]

So -- all good?

 

[ayazgreat]

Shg yes I need a formula specially for each additional k g I have numbers of items which I have to add manually

 

[shg]

The formula INCLUDES the calculation for extra kilograms; did you try it?

 

[ayazgreat]

Your previous provided formula is giving error of #N / A

 

[shg]

Posted temporarily at https://app.box.com/s/f2c155ffe8c327dc7237

 

[ayazgreat]

Posted temporarily at https://app.box.com/s/f2c155ffe8c327dc7237

Thank you very much shg, it works however you have changed first table view and put a formula, but it is ok

 

[shg]

So -- all good?