View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ronzander1
 
Posts: n/a
Default excel multiply by different values based on quantity

I would like to multiply the value of a cell based on quantity.

Think of it as paying more (higher multiplication factor) for a few pounds
of something, and paying less for bigger quantity (lower multiplication
factor) and then and paying far less still for a huge quantity (even lower
multiplication factor)

I need to have at least three variables to make my factors work. THANKS!