View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hello hello is offline
external usenet poster
 
Posts: 27
Default 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