Forum Discussion
Solved
Interpolating values between two dates
Hi, I hope you are all well! I currently have a dataset containing monthly financial data and quarterly financial data. I wish to linearly interpolate the quarterly data to monthly data so I ...
HiScottF123,
I would create an auxiliary column with a formula that outputs the interpolated values. You could then save these values in your table (only copy them as values).
I have made an example. I hope you already have the LET() function, because I used it in my interpolation formula.
Have a look at the file to see if it comes close to your ideas.
HiScottF123,
I would create an auxiliary column with a formula that outputs the interpolated values. You could then save these values in your table (only copy them as values).
I have made an example. I hope you already have the LET() function, because I used it in my interpolation formula.
Have a look at the file to see if it comes close to your ideas.
