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.
2 Replies
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.
