View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rudyeb rudyeb is offline
external usenet poster
 
Posts: 9
Default 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?