Hello - I desperately need help urgently with this one.
I have a list of values (Column A) with a corresponding reference value (Column B).
In E1 the user enters any value. E2 is then to calculate the extrapolated corresponding value from column B.
for example.
User enters 0.6 in E1.
E2 is supposed to work out a reference value based on what is available in columns A & B.
So the nearest values is 0.5 and 1. with corresponding reference values of .08 and 0.1
E2 therefore needs to be a value somewhere between .08 and 0.1
how is that calculated? the majority of it is linear but not all of it.
Thanks for any help
Bookmarks