Rebate percentage

[Mavrick69]

Hi Guys,

Like most I have a question. I'm sure it can be done, but I'm going round in circles.



Price of item 1 £10.
Rebate required 5%
Item 1 inflated by ??% So true rebate of 5% is calculated on the difference and the customer is credited with this value

I need to know how I can get excel to work that out.

To be honest, I'm still not sure I have explained it correctly.

Thanks
Mike

[gebobs]

I think you need to give an example.

[gebobs]

Orig_price=£10
Infl_price=£11
Credit=5%*(Infl_price-Orig_price)

Is this what you need?