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


"Raymond Ray" wrote:

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?