I have a table of data which provides ranges that my inputs can fall between
"Table"
1600
1470
1330
1200
1070
930
820
780
680
590
Basically when I get a number say 1220, I want to check which values it is in between and then compute the percentage the 1220 is of the range.
For example
IF 1220 is in the range of the "table", find what two values it is between which is 1330 and 1200.
then take the number above 1220 which is 1330 and the number below 1220 which is 1200 and perform this calculation
(1330-1220)/(1330-1200) to get a percentage of the range.
Cheers
Any ideas would be appreciated.
Bookmarks