apply different prices to different quantities (variable pricing?)

[Guest]

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?

 

[Guest]

Assuming the 3500 (or other quantity) is in A1, then this will work from any
other cell:
=IF(A1>2000,0.006*2000+0.003*(A1-2000),0.006*A1)

 

[Guest]

That worked. Thank you.

Assuming the 3500 (or other quantity) is in A1, then this will work from any
other cell:
=IF(A1>2000,0.006*2000+0.003*(A1-2000),0.006*A1)

 

[Roger Govier]

Hi Raymond

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