L
Legacy 220867
Guest
Hi, I have a list with data for vehicles' speed vs grade%.
I'm currently using this formula but is suspecting that this is not very accurate and gives errors:
=FORECAST(I10,OFFSET(speed_loaded1,MATCH(I10,grade_loaded1,1)+1,0,2),OFFSET(grade_loaded1,MATCH(I10,grade_loaded1,1)+1,0,2))
Can someone please give me an easy and accurate way of interpolating? I have a list with grade% vs the speed a certain vehicles can travel up that grade/slope. So given a certain grade%, I want to interpolate for the speed.
Any help will be much appreciated. Thanks!
I'm currently using this formula but is suspecting that this is not very accurate and gives errors:
=FORECAST(I10,OFFSET(speed_loaded1,MATCH(I10,grade_loaded1,1)+1,0,2),OFFSET(grade_loaded1,MATCH(I10,grade_loaded1,1)+1,0,2))
Can someone please give me an easy and accurate way of interpolating? I have a list with grade% vs the speed a certain vehicles can travel up that grade/slope. So given a certain grade%, I want to interpolate for the speed.
Any help will be much appreciated. Thanks!
![smile.gif](/board/proxy.php?image=http%3A%2F%2Fwww.excelforum.com%2Fimages%2Fsmilies%2Fsmile.gif&hash=2b23f960121a0ec03857d042b98d59dc)