I have a cell which gives the result of a model which is fed by numerous variables. One of which is the price of a product. I'm looking to evaluate the impact of percentage discounts from 1% to 100% without manually changing the price cell each time.
Ideally the code would create an output table of % discount and copy and paste result cell value.
i.e:
1% £10,000
2% £9,990....
This is hard to explain so I have attached a simplified spreadsheet where the cells which need changing are C5:C7 and the result cell is I5.
Many Thanks,
James
Bookmarks