Forecasting Linear?

[gheyman]

If I have two Quantities and two Unit Prices, is the a formula that will forecast another qty?

Qty 100 = $25.00
Qty 500 = 10.50

Is there a formula that would forecast Qty 300 or any other quantity I enter that is between 100 and 500 (Using a straight line)?

Thanks

 

[Eric W]

Well, there is the FORECAST function!

Book1
	A	B	C	D	E
1	x	y		x	forecast y
2	100	25		300	17.75
3	500	10.5
Sheet2

Cell Formulas
Range	Formula
E2	=FORECAST(D2,B2:B3,A2:A3)

 

[joeu2004]

=FORECAST(A1,{25,10.5},{100,500})

where A1 has the value of "any other quantity" (e.g. 300).