Hi,
I would like to mimic goal seek for the following but unsure how?
Current RRP
New RRP
Current Selling price
New Selling Price
Current Margin = (RRP-VAT) - Selling Price
I would like to change the current RRP (i.e £2.50) to a New RRP (£2.40) which then changes the current selling price...