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?

apply different prices to different quantities (variable pricing?)
 

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?

apply different prices to different quantities (variable prici
 

That worked. Thank you.

"JLatham" wrote:

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?

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?