AA	        AB	AC	AD	AE	        AF	 AG	         AH	AI	AJ
0.7	      SubScore	2	SubScore98	        SubScore 98	       SubScore		
0.448840495	7.48		7.48	99.66021651	2.26	99.78083497	2.26	97.33	97.33
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.7929014	2.26	97.33	97.33

##</code><code>##

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

##</code><code>##

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))))
AC [EMPTY CELL]
AD =IF(AC15<AC$13,IF(AC15<AC$12,AC$8,((AC15-AC$13)*(AC$8-AC$9)/(AC$12-AC$13))+AC$9),IF(AC15>AC$14,AC$10,AC$9-((AC$13-AC15)*(AC$9-AC$10)/(AC$13-AC$14))))
AE 99.6602165102621
AF =IF(AE15>AE$13,IF(AE15>AE$12,AE$8,((AE15-AE$13)*(AE$8-AE$9)/(AE$12-AE$13))+AE$9),IF(AE15<AE$14,AE$10,AE$9-((AE$13-AE15)*(AE$9-AE$10)/(AE$13-AE$14))))
AG 99.7808349699302
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 value. By default its 97.33. Exact value is 99.34)
AJ =AI15