Priceslist help

[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

[Dave Peterson]

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.


cb1376 wrote:
>
> 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
>
> --
> cb1376
> ------------------------------------------------------------------------
> cb1376's Profile: http://www.excelforum.com/member.php...o&userid=32026
> View this thread: http://www.excelforum.com/showthread...hreadid=517789

--

Dave Peterson

[famdamly]

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.