Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i have a question. i am trying to find a function or some way to help me
interpolate a range of numbers to find a given value. say i have the range of numbers below. X Y 1 100% 1.5 90% 2 80% 2.5 70% 3 60% 3.5 50% 4 40% 4.5 30% 5 20% Now i want to find the value of X that corresponds to a Y value of 65% now obivioulsy the value is going to be 2.75, but say i have a harder range of numbers is there a way i can do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Interpolating between two points | Excel Discussion (Misc queries) | |||
interpolating - how do i get/use the solver? | New Users to Excel | |||
Interpolating an x, y point from known x's and y's | Excel Worksheet Functions | |||
Interpolating an x, y point from known x's and y's | Charts and Charting in Excel | |||
Help with Interpolating for a value. | Excel Worksheet Functions |