We have an excel spreadsheet that needs a factor, one cell, that can modify over 900 cells.
It is a price list of over a 250 items which have 4 prices each. We want to have one cell that we can modify, a multiplier, that will modify each cell.
If the cost of the cabinet is $50 and we have a 30% multiplier the box should now list $65
The attached file shows the first section of the spreadsheet and an explicit example of what all the pricing should be able to be adjusted to.