I need help figuring out how to do something I'm almost positive can be done. Let me try to explain. I have a spreadsheet that lists multiple product prices for multiple locations. I want to have a cell off to the side, that I can add a discount too. I want the base prices to remain the same, but when I enter say -10 to the cell, it will adjust all prices by that amount. When the discount is removed, the prices revert to where they were. The spreadsheet is 18 rows and 7 columns. Does that make sense? Can this be done?
Bookmarks