In the table: the district Beijing, hebei province, shanxi
Value 2.16% 1.08% 1.56%

When the ratio is greater than the national average in a given area, each 0.02% above average, plus 1 minute, the highest plus 30 points,
When the ratio is less than the national average in a given area, each is lower than the average 0.03%, minus 1 points, maximum reduction of another 30 points,

CodePudding user response:

Can accept VBA

CodePudding user response:

1 A B C D
2 area of Beijing in hebei, shanxi

3 value 2.16% 1.08% 1.56%Four score

 B4=MEDIAN (30, 30, ROUNDDOWN ((B2 - business ($B $2: $D $2))/IF (B2 & gt;=business ($B $2: $D $2), 0.02%, 0.03%), 0))