Need help with calculating Net Chargeable amount

[avash84]

Hi Team,

Hi I am trying to create a formula to find the net chargeable amount.

Lets say [TABLE="width: 222"]
<colgroup><col></colgroup><tbody>[TR]
[TD]A2=Chargeable weight
B2= price per kilo post 15 kilos for the 1st 5 kilos
C2= price per kilo after that[/TD]
[/TR]
</tbody>[/TABLE]

e.g. If the total weight is 25 kgs, I want the formula to work out the price such that the net chargeable amount would be Rs. 2000.

Thanks in advance.

 

[Special-K99]

Not enough info.

Why would it be Rs 2000?

It's impossible to determine how you get Rs 2000 since you've supplied no price information.

Explain how you get Rs 2000.