Avg. price increase

[goldcomac]

I had to make a new post. It wasn't letting me tack on to the thread.


My original question starts at the bottom and I am looking for a
weighted average. I've got 15 - 20 different packages I sell this
customer and can't go over a 6% price increase in total. Some packages
can be higher and some can be lower.

Thanks.

 

[Joel]

You may want to do this interactively on the worksheet. Put the percentage
increase for all items in one column and then put formula =average(a1:A25)
and the bottom of the column. change perrcentages until you are happy.

You may want to do it by price instead of percentage. the put old price in
column A, New Price in column B. Column C put percentage increase. then put
=average(C1:C25) at bottom of column. Then change prices until you are happy.