Change values in multiple cells from one cell

Z

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
 
G

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%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top