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

A2=Chargeable weight B2= price per kilo post 15 kilos for the 1st 5 kilos C2= price per kilo after that

<colgroup><col></colgroup><tbody>
</tbody>

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.