Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weighted Average
I need to take a price increase on some of my products. I am allowed
to take 4% per year - total. I have some products that do not need increasing and some that do. Example: Item "A" - no increase Item "B" - $0.25 per unit Item "C" - $0.18 per unit Item "D" - no increase Item "E" - no increase Item "F" - $0.11 per unit etc I am trying to create a spreadsheet which will allow me to put the current selling price in one column, the proposed selling price in another column, the percent increase in a third column, and the weighted average increase in a final column. I'm hoping that this column will update each time I put in a new price. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weighted Average | New Users to Excel | |||
Weighted Average | Excel Worksheet Functions | |||
Weighted Average | New Users to Excel | |||
Non zero weighted average | Excel Worksheet Functions | |||
Weighted Average | Excel Discussion (Misc queries) |