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