Forum Discussion
Solved
Non-linear interpolation
Any idea how I can achieve this? I need to return the value in column B based on an input in column A. Data example as follows: A B 10 4 15 ? 20 2.5
I have just tried it with linear interpolation via the forecast function and it now works. I think I got my wires crossed, apologies.
With linear interpolation it would be easy.
Can you explain what kind of interpolation you want (and why)?
I have just tried it with linear interpolation via the forecast function and it now works. I think I got my wires crossed, apologies.