| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pricing decreases as quantity increases- how to do that
When I purchase raw material, the more I buy the less it costs per
pound. I would like to be able to enter historic data and then have Excel give me a price that would be in line with that data. Meaning if I bought 100 lbs at $3.50/lb and 127 lbs at $3.02/lb what would the cost be of 185 lbs using those numbers? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show decreases and increases | Charts and Charting in Excel | |||
| Graph with stepped increases or decreases | Charts and Charting in Excel | |||
| Conditional Formatting - Increases/Decreases | Excel Discussion (Misc queries) | |||
| Need a formula to increase quantity of one cell until the quantity ofanother is exceeded | Excel Discussion (Misc queries) | |||
| How can I increase value in one cell as value in other decreases? | New Users to Excel | |||
Threaded Mode
