Select Code to Download

AA            AB    AC    AD    AE            AF     AG             AH
+    AI    AJ
0.7          SubScore    2    SubScore98            SubScore 98       
+    SubScore        
...
0.584906759    7.48        7.48    99.66985331    2.26    99.79158604 
+   2.26    97.33    97.33
0.632038673    7.48        7.48    99.67817389    2.26    99.79316929 
+   2.26    97.33    97.33
0.599607733    7.48    #N/A    7.48    99.6643225    2.26    99.792901
+4    2.26    97.33    97.33

0.448840495    7.48        7.48    99.66021651    2.42    99.78083497 
+   2.45    99.34    99.34
0.584906759    6.93        7.48    99.66985331    2.42    99.79158604 
+   2.45    98.80    98.80
0.632038673    6.87        7.48    99.67817389    2.43    99.79316929 
+   2.45    98.69    98.69

AA 0.448840495386917   
AB =IF(AA15<AA$13,IF(AA15<AA$12,AA$8,((AA15-AA$13)*(AA$8-AA$9)/(AA$12-
+AA$13))+AA$9),IF(AA15>AA$14,AA$10,AA$9-((AA$13-AA15)*(AA$9-AA$10)/(AA
+$13-AA$14))))
...
AH =IF(AG15>AG$13,IF(AG15>AG$12,AG$8,((AG15-AG$13)*(AG$8-AG$9)/(AG$12-
+AG$13))+AG$9),IF(AG15<AG$14,AG$10,AG$9-((AG$13-AG15)*(AG$9-AG$10)/(AG
+$13-AG$14))))
AI =SUMIF($C$14:$AH$14,"SubScore",C15:AH15)    (I need to read this va
+lue. By default its 97.33. Exact value is 99.34)
AJ =AI15