Trying to Create a Pricing Curve

[Jgonz115]

I have three quantities with prices:

30 - $6,313
100 - $5,592
300 - $5,261

I am trying to determine the price for each quantity in between the quantities above (31, 32, 33, 34, 35 etc).
Honestly I am completely stuck and any help is greatly appreciated.

Thanks!

 

[Gerald Higgins]

Hi, welcome to the board.

This looks like maybe a maths / statistics question rather than an Excel question.

Anyway, tell us, what should the answer be for 31 ?

 

[Eric W]

Is this just a pricing scheme where if you order 1-29 of an item, each item costs $6313, and 30-299 costs $5592 each, etc.? If so:

Book1
	A	B	C	D	E
1	Quantity	Price		Quantity	Price
2	31	$ 5,592.00		0	$ 6,313.00
3				30	$ 5,592.00
4				300	$ 5,261.00
Sheet4

Cell Formulas
Range	Formula
B2	=VLOOKUP(A2,$D$2:$E$4,2)