Priceslist help

  • Thread starter Thread starter cb1376
  • Start date Start date
C

cb1376

Hi all,
I am new to excel so go easy on me! I am trying to complete a
pricelist. I have over 500 items each with 11 different prices. I would
like to enter the cost price for all the items in the cells but Is there
a formula I can enter so if I enter say for e.g.. 30%, 45%, 50%, 60% as
my markup the cost price in the cells will change depending on the
percentage I enter. As all 500 of my items prices change weekly.This
will save me loads of time. I hope I have made myself clear. I
appreciate your help.
Clare
 
If you haven't entered the prices, you could use a formula:

=$a$1*(yourpricehere)

And then put 1.30 (or 130%) in A1.

You'll be able to modify all the cells with that kind of formula.

If you've already entered the prices, you could do this:

Select an empty cell (I used B1)
put this formula in that cell:
=$a$1
(A1 is the cell that will hold this factor).

Select that cell (B1)
edit|copy
select your range of prices
edit|paste special|check multiply

You'll end up with a bunch of formulas that look like:
=123.45*($A$1)

Now clear up that helper cell (B1) and just put your factor in A1.
 
Speaking of price lists. Anyone know of a template out there for all to
use that we could just enter the items and the current cost. Then
everytime there is a price change we can update it and it gets time
stamped. Then later we can view graphs of the costs. Something that is
pretty generic but all set up.:confused:
 
Back
Top