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:
I really hope someone can help.
Thanks in advance!
9 Replies
I wrote this spreadsheet for another post but it applies here.
The difference is that the spreadsheet formula looks up the closest points for which data is provided rather than the input being uniquely identified.
PeterBartholomew1 Thank you Peter for your reply.
I don't actually need the Lookup function as the data will always change, so I would need to manually enter the data anyway.
I tried using your formula but it doesn't give me the answer I need.
- It gave the answer you quoted to 6s.f.
That aside, it may go better if you inform the forum of the Excel version you use (my formulation is specific to Excel 365) and ideally provide a workbook to demonstrate how the input is held and the required solution.
