Change values in multiple cells from one cell

[zeewaa]

I would like to change multiple cells values by just changing a value in one
cell. Example: I have a price sheet with multiple values I change at
different times. But I would like to change all the values based on my
customer. like if he is one of my higher users I would like to give him a
bigger discount.

What I would like is make a cell at the top of my workbook that would allow
me to put in a percentage value that I can change whenever I want want and it
will change all the values Ive selected to change that amount

 

[Gary''s Student]

Let's say cell A1 is the single cell and that column C contains that normal
prices (un-discounted).

First enter .85 in A1 then copy A1 and paste/special/multiply into the
prices in column C. This will result in all the prices beith discounted by
15%