need the score based on range

[sksanjeev786]

Hi Team,


I need to change the data between

― Excellent (80-100)

― Above Average (60-79)

― Average (40-59)

― Below Average (0-39)

From Range F23 to M29 based on data F13 to M19

so I have already written the formula with the range in F23 so I am getting same data like 99,79,59 and 39 so now I need to +2 Different if scores are same
like F23,I23,K23 and M23 all score the same as 99 but if we have same score in a row then can we see data F13 to M13 and based on that score just add the data +2
from 80+ ( since it is coming in Excellent range)

			Below Average Delta	Average Delta	Above Average Delta	Excellent Delta
		Measure	Under 40th	40-60th	60th-80th	80-100%
		Unaided Awareness First	12.9	19.0	25.7	66.7
		Unaided Awareness Total	11.7	17.5	26.1	63.8
		Aided Brand Awareness	1.4	4.0	8.0	41.6
		Brand Favourability2	2.2	5.0	8.6	31.3
		Consideration2	2.0	5.0	9.0	26.7
		Online Ad Awareness	5.8	9.0	13.5	34.8
		Love/Hate	-0.1	1.3	3.0	8.8
		Unaided Brand Awareness (First Mention)	27.2	15.6	22.0	37.0	25.0	28.0	28.5	27.7
		Unaided Brand Awareness (Any Mention)	26.7	15.5	23.0	34.0	24.0	30.1	25.0	25.7
		Aided Brand Awareness	-0.1	-4.2	-2.0	1.0	-1.0	-4.1	1.2	2.1
		Brand Favorability	-5.7	-4.2	-4.0	1.0	2.0	-0.7	-0.3	3.6
		Consideration Intent	0.9	3.3	2.0	11.0	4.0	5.5	-0.5	4.9
		Online Ad Awareness	9.3	-1.4	8.0	20.0	16.0	19.9	17.4	19.2
		Affinity	-6.5	4.5	-8.0	-2.0	4.0	4.6	3.5	3.5
			99	59	79	99	79	99	99	99
4	99	― Excellent (80-100)	99	59	79	99	79	99	79	79
3	79	― Above Average (60-79)	39	39	39	39	39	39	39	59
2	59	― Average (40-59)	39	39	39	39	39	39	39	59
1	39	― Below Average (0-39)	39	59	39	99	59	79	39	59
			79	39	59	99	99	99	99	99
			39	99	39	39	99	99	99	99