<div>
<div class="content wysiwyg-content">
i have the values<br />
<br />
for 470 &nbsp;--&gt;1<br />
for 440 --&gt;3<br />
i want to find value for 450<br />
<br />
using Excel =FORECAST(450,B16:B17,A16:<wbr />A17) it gives me 2.33 but the manual gives 1.8<br />
<br />
what did i do wrong ? 
</div>
</div>


i have the values

for 470  -->1
for 440 -->3
i want to find value for 450

using Excel =FORECAST(450,B16:B17,A16:A17) it gives me 2.33 but the manual gives 1.8

what did i do wrong ? 

interpolation

The Math / Science topic primarily includes discussions of mathematics, physics, statistics and economic analysis, but also biology, chemistry and other sciences.

Math / Science

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.