| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I interpolate values into a range?
Hi
I would like to interpolate values into a range. Column B are the data. I would like to linearly interpolate the values in column B into the ranges in column A. If it is easier, it is OK to assume that the value in column B is for the midpoint of the ranges in column A. Thank you A B 18-19 17.5 20-24 33.8 25-29 53.1 30-34 68.0 35-39 85.3 40-44 97.5 45-49 100.0 50-54 97.2 55-59 91.1 60-64 53.5 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I interpolate values off a table? | Excel Worksheet Functions | |||
| Having this tablet X;Y values how can I make interpolate between e | Excel Worksheet Functions | |||
| interpolate | Excel Worksheet Functions | |||
| How to interpolate in an array forX and Y values to get Z? | Excel Worksheet Functions | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
Linear Mode
