Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an interpolation
Hi folks,
I am using Excel 2007, and I have an interesting issue... I have a column of numbers: 0, 500, 1000, 2000, 4000, 6000 and 8000 feet The next column are calculated formulae for takeoff distances for the related altitudes in column 1. What if I would like to calculate 750 feet? Or 3000 feet? Is there a formula I can use to interpolate between the columns? Thanks very much, Craig |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an interpolation
The =FORECAST() function does a good job of interpolating as well as
forecasting. See Excel Help or: http://support.microsoft.com/kb/828236 -- Gary''s Student - gsnu2007i "TheMilkGuy" wrote: Hi folks, I am using Excel 2007, and I have an interesting issue... I have a column of numbers: 0, 500, 1000, 2000, 4000, 6000 and 8000 feet The next column are calculated formulae for takeoff distances for the related altitudes in column 1. What if I would like to calculate 750 feet? Or 3000 feet? Is there a formula I can use to interpolate between the columns? Thanks very much, Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
interpolation | Excel Worksheet Functions | |||
interpolation | New Users to Excel | |||
3D Interpolation | Excel Worksheet Functions | |||
Interpolation | Excel Worksheet Functions | |||
help with interpolation and limit of interpolation | Excel Discussion (Misc queries) |