Thread: apply different prices to different quantities (variable pricing?)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Raymond Ray Raymond Ray is offline
external usenet poster
  
Posts: 2
Default apply different prices to different quantities (variable pricing?)
I need to apply a different price to different quantities in the same number.
For example, my volume is 3500 (input cell). I need to apply $.006 to the
first 2000, and $.003 to anything above 2000. What is the formula?
Reply With QuoteReply With Quote