=IF(D5>=2.29,"100",IF(D5>=2.28,"98",IF(D5>=2.26,"96",IF(D5>=2.25,"94",IF(D5>=2.22,"92",IF(D5>=2.2,"90",IF(D5>=2.17,"87","")))))))&IF(D5>=2.12,"84",IF(D5>=2.08,"81",IF(D5>=2.02,"78",IF(D5>=1.95,"75",IF(D5>=1.92,"72",IF(D5>=1.87,"69",IF(D5>=1.81,"66","")))))))&IF(D5>=1.74,"63",IF(D5>=1.67,"60",IF(D5>=1.65,"50",IF(D5>=1.63,"40",IF(D5>=1.6,"30",IF(D5>=1.56,"20",IF(D5>=1.52,"10",""))))))) 请帮改下!
|