I would make a lot of changes to the layout to get the data into a
standard table. This means you will need to figure out the answers once
for each pair and populate the table. After that, a simple INDEX/LOOKUP
will do the trick.
Unfortunately, LOOKUP rounds DOWN, so you'll also need to renumber the
range to show the LOWER number of each range.
So the values 4, 8, 12, 17 will change to 0, 4.001, 8.001, 12.001
and the values 6, 10, 12, 15.75 will change to 0, 6.001, 10.001, 12.001
This workbook shows how it looks up the values. This is one approach.
+-------------------------------------------------------------------+
|Filename: NewTable.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=58|
+-------------------------------------------------------------------+
--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile:
http://www.thecodecage.com/forumz/member.php?userid=73
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=46465