discount entire columns

  • Thread starter Thread starter dan
  • Start date Start date
D

dan

let me give a more precise example of what I'm trying to
do.

I have a number of "list prices" in a column lets say
column "A", rows 5-10 each have a different "list price".
Then I have a mark-up or discount amount ie x 1.4 in cell
A1, I want to be able to change the number in A1 to 1.5 or
1.6 or 1.7 or whatever and have every number in cloumn "A"
rows 5-10 change to the new amount together. without
going to each cell in each column and entering in a
formula for each. they are all diiferent prices, but they
all will have the same discount.

you'll have to forgive me, I used to have a spreadsheet
that did this perfectly that someone else made for me so I
just took it for granted until a virus wiped out my system
now I have no idea how it works lol.

Dan
 
Hi Dan!

Save your file and then save under a new name so that you can revert to the
original if / when you stuff up <vbg>

Put the mark up or discount multiplier in an empty cell:

So for mark up you might have 1.2 to mark up 20% and for discount you might
have 0.8 to discount by 20%

Select the mark up / discount cell
Copy
Select the range that you want to mark up or discount
Edit > Paste Special
Check Multiply
OK

BTW, it's best to stay in the original thread rather than create a new one
even if you're re-phrasing / re-defining what you want.
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top