早教吧作业答案频道 -->其他-->
我这个怎么改啊,结果不对,前边的得数都太大不知是怎么回事?=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(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}))
看了我这个怎么改啊,结果不对,前边...的网友还看了以下:
点评以下句子1、山那边的山啊,铁青着脸.2、一次次漫湿了我枯干的心灵.3、我每次只移动一小步,慢慢 2020-04-26 …
a,b为锐角,sina=8/17,cos(a-b)=21/29,求cosb我算出答案是475/49 2020-05-16 …
有谁知道"培养"的"培"的右半边加上个"瓦"是什么字啊?说明说明啊,"培养"的"培"的右半边是这个 2020-06-15 …
下列图形经过一次操作后所得的图形与原图不一定相似的有-------()A、三角形剪去一个角所得的图 2020-07-06 …
我弟拼音从a学到了h,老师布置作业让把18个音节各写一行,这18个音节是哪些啊?从a到h也才17个 2020-07-10 …
CRC(16位)多项式为X16+X15+X2+1其对应校验二进制位列为11000000000000 2020-07-23 …
一个小球在大碗里向下滚动,他是上边滚得快,还是在下边滚得快.A.斜面的坡度越小,球滚得越慢.这便是 2020-07-30 …
我这个怎么改啊,结果不对,前边的得数都太大不知是怎么回事?=IF(D5>=2.29,"100",IF 2020-10-31 …
有没有人知道土耳其海峡曼德海峡霍尔木兰兹海峡是位于哪里呢?(具体一点啊~但不要讲经纬度啊~因为本人不 2020-11-01 …
英语翻译我们好久没有联系了,你最近还好吗?我们放假了,我去了云南那边,昨天才回来!好想你哦```你在 2020-12-26 …