Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am looking for a formula to tell me the quanity to buy given the following.
I want to buy something at 3 or more different prices. I want the average cost as we increase in price to be $1.00 below the purchased price. I want to know how many I have to buy to bring the average up to $1.00 below the purchase price and continue to do this as we make the next purchases at the next higher price we choose. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Weighted Average Using Row Number | Excel Worksheet Functions | |||
Weighted Average | New Users to Excel | |||
Weighted Average | New Users to Excel | |||
Weighted Average - Copy Function | Excel Worksheet Functions | |||
Show weighted average value after filter. | Excel Worksheet Functions |