Thread: apply different prices to different quantities (variable pricing?)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default apply different prices to different quantities (variable pricing?)
Hi Raymond

One way
=A1*0.03+MIN(2000,A1)*.03

--
Regards

Roger Govier


"Raymond Ray" wrote in message
...
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