| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get values in between data?
thanks martin.
"MartinW" wrote: Say your interpolated value is in Sheet1 cell F1, Put this in the other Sheet =Sheet1!F1 You can reference another sheet like that in any formula. HTH Martin "Oligo" wrote in message ... "MartinW" wrote: Hi Oligo, If you are looking for a straight line fit between data points, try this approach. Put this formula in D1 and drag it down to D4 =IF(AND($E$1=A1,$E$1<=A2),TREND(B1:B2,A1:A2,$E$1) ,0) In F4 put this =MAX(D1:D4) Put a new value for A into E1 and F1 will reflect the corresponding B value. HTH Martin thanks martin. but now i got another issue. your interpolate formula solve the problem. but i need the interpolated value to be reference in formula on another worksheet. so now i dont know how to reference to the cell since the interpolation values will only be adjacent to the cell that match the if analysis. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data values | Excel Worksheet Functions | |||
| Excel chart source data y-values can only accept 7 data pts? | Charts and Charting in Excel | |||
| How do you get the values of the data between data points | Excel Worksheet Functions | |||
| why do I get the multiple data values when there is no data in my. | Excel Worksheet Functions | |||
| If I have X,Y data how do I sum the Y values using a set of bins based on x values | Excel Worksheet Functions | |||
Threaded Mode
