Forum Discussion
Solved
Input X coordinate on graph and output Y coordinate?
Good Afternoon, I am trying to find a way to output the Y coordinated of a point of a graph when I input a X coordinate. Is there a function or formulae that would allow me to do this. I have tri...
Thanks. The attached version uses linear interpolation. The X is in F30 and the results in F31:F33.
I left some helper formulas in G30:H33. If you wish, you can substitute them into the formulas in F31:F33.
HansVogelaar Sorry for the delay. Here is a worksheet with the data and graph I am trying to work with. You help is appreciated!
Thanks. The attached version uses linear interpolation. The X is in F30 and the results in F31:F33.
I left some helper formulas in G30:H33. If you wish, you can substitute them into the formulas in F31:F33.
- Thank you so much, this is exactly what I needed