I find that I first need to understand the problem mathematically before doing it in Excel.
1st guess at an algorithm is that you want a basic linear interpolation algorithm.
Then you want to "lookup" where your study score/percent fits in the "known x" column, then use linear interpolation to compute the score "known y". Does that sound right?
If that is correct, one way I have used to perform linear interpolations is to compute the "slope" and "intercept" for each pair of entries in adjacent columns, then structure a lookup function to pull the slope and intercept from the lookup table. known y can then easily be calculated from the study percent. Here's a similar example I put together for someone else:http://www.excelforum.com/excel-char...ml#post3904113 note in particular the lookup table in columns H, I, J.
Bookmarks