Hi,

I have some pricing data in a spreadsheet with a range (when there is a minimum and maximum value), of the form min-max (£200-£220 for example).

In the same spreadsheet I have prices that are set, that dont have a minimum/maximum (for example just £200).

I have a formula set up that will change all of the values by an amount that I enter into a box for the weekly price change, that changes all of the set prices by whatever the amount is, i.e. if the change is +20 it'll move from £200 to £220. But I cannot find a way to do this automatically for a range, i.e. change £200-£220 to £220-£240.

Does anyone have any ideas?

Steve