Forum Discussion
kirkbiddlecombe
Jul 08, 2025Copper Contributor
Non-linear interpolation formula
I have been trying to do this for a while but without success. There is a formula somewhere (using a power law relationship or something) but I have not been able to do it.
I basically need to find a corresponding value (column B) based on an input in column A.
| A | B |
| 10 | 5 |
| 20 | 2.5 |
If the inputted value (in column A) is 15, then the output in column B would be 3.75.
Any way of creating such a formula in Excel? Columns A & B hold a non-linear relationship.
Any assistance would be hugely appreciated.
Thanks.
1 Reply
Also asked, and answered by yourself here: Non-linear interpolation | Microsoft Community Hub