早教吧作业答案频道 -->其他-->
我这个怎么改啊,结果不对,前边的得数都太大不知是怎么回事?=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}))
看了我这个怎么改啊,结果不对,前边...的网友还看了以下:
将一组数字按如图2方式排列,若(m,n)表示第m排从左到右第n个数,则(5,4)表示的数是____ 2020-05-15 …
c语言 当x0时 y=1y=-1;if(x!=0)if(x>0)y=1;elsey=0;这是程序的 2020-05-16 …
2.火药是我国四大发明之一,他所需用的原料,硝酸钾,硫磺,木炭的质量比是15:2.火药是我国四大发 2020-05-17 …
有一包白色粉末,其中可能含有Ba(NO3)2、CaCl2、K2CO3,现做以下实验:1、将部分粉末 2020-05-19 …
(1)已知一次函数y1=k1X+2在x=5时,y1=4;一次函数y2=k2X-6的图像经过点P(- 2020-05-22 …
已知圆C:x2+(y-3)2=9,过原点作圆C的弦OP,则OP的中点Q的轨迹方程为()A.(x-3 2020-06-04 …
heaskedherifshehadenjoyedthespeech.请问if在这里属于什么语法点 2020-06-18 …
1.在2只杯子中分别注入等量的自来水(约1/4体积),在其中一只杯子中家人2勺食盐和一些碎冰块,另 2020-07-08 …
2.一个静止的氢离子(H+)在电场中被加速而获得的速率为一静止的氧离子(O+2)在同一电场中且通过 2020-07-12 …
求EXCELif函数高手(有关超过7个条件的),=IF(A1=1,"A",IF(A1=2,"B", 2020-07-23 …