Forum Discussion
Interpolation in Excel
Hi All, I am hoping someone can help me with an issue I have been having. I am trying to add an Interpolation sum in one of my spreadsheets but I just can't figure out how. Below is the sum: ...
No, the pw only tells you which values to use. I'm basically given a set of data and with this data, I have to find the appropriate values from the table. Then use interpolation to find a more accurate CU value.
Do you need me to remove the XLOOKUPS or can you
a) use them, or
b) remove them and link to data cells
a) use them, or
b) remove them and link to data cells
I thought I had given up the process of manual lookups when logarithm tables faded into obsolescence! In theory I could use those direct cell reference thingies -- but its against my religion.
Joking aside, I hope this is what you want.
- Remove them and link to data cells. I'll just manually input the data into specific cells.