Hello all,
I consider myself on the lower end of experience when it comes to this type of thing and I suspect it should be easy to accomplish, although I don't know exactly how to word it to find the solution by searching.
I have several sets of limit lines on data that we test for at work in the format of (5, 0.15) to (1200, 0.25) and now have a customer that needs the intermediate ("Y" values) at the following ("X") points [5, 400, 500, 750, 800, 1000, 1100, 1200].
Is there a simple formula, graph&function, or code that could accomplish this task? I realize that I could plug it into a graphing calculator, but there are quite a few points on quite a few limit lines that I would need to do this for and I feel that there has got to be a better way.
Thanks in advance for any advice.
10:29 CST EDIT: added worksheet I am working on currently as an example in case it is needed. The cells I refrenced in the main post are as follows:
(5, 0.15) to (1200, 0.25) would be in worksheet "current test specs" and cells (B3, D3) to (C3, E3) and the place I would need to place the results would need to be worksheet "F-40000-A" and cells D2:G2
I have sanitized the worksheet and removed all the duplicates of the other part numbers, but it should serve to explain any confusion.
Bookmarks