早教吧 育儿知识 作业答案 考试题库 百科 知识分享

我这个怎么改啊,结果不对,前边的得数都太大不知是怎么回事?=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(D

题目详情
我这个怎么改啊,结果不对,前边的得数都太大 不知是怎么回事?
=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","")))))))
▼优质解答
答案和解析
=IF(ISNA(LOOKUP(D5,{1.52,1.56,1.6,1.63,1.65,1.67,1.74,1.81,1.87,1.92,1.95,2.02,2.08,2.12,2.17,2.2,2.22,2.25,2.26,2.28,2.29},{10,20,30,40,50,60,63,66,69,72,75,78,81,84,87,90,92,94,96,98,100})),"",LOOKUP(D5,{1.52,1.56,1.6,1.63,1.65,1.67,1.74,1.81,1.87,1.92,1.95,2.02,2.08,2.12,2.17,2.2,2.22,2.25,2.26,2.28,2.29},{10,20,30,40,50,60,63,66,69,72,75,78,81,84,87,90,92,94,96,98,100}))