How to calculate different slab rates for different weights

[Mustafa Ahmedali]

I have to calculate Weight Handling Fees based on the following criteria:

Each 500 gram Up to 2 Kg @ 45/- Required formula result as
for 1.75 Kgs 180/-
for 1.10 Kgs 135/-
for 0.90 Kgs 90/-

Every additional 500 gram @ 30/- Required formula result as
for 2.25 Kgs 210/-
for 2.60 Kgs 240/-

[Pete_UK]

Assuming the weight is in A2 in grams (so 1.2 Kgs should be entered as 1200), then you can have this formula in B2:

=ROUNDUP(MIN(A2,2000)/500,0)*45 + ROUNDUP(MAX(0,A2-2000)/500,0)*30

Hope this helps.

Pete

[JeteMc]

Try the following formula:

=IF(A2<=2,ROUNDUP(A2/0.5,0)*45,180+ROUNDUP((A2-2)/0.5,)*30)

Here it is applied to a file where the weight is entered in A2 and the fee is reported in B2:
Slab Wieghts.xlsx
Let me know if you have any questions.

[JohnTopley]

Removed by JT