excel大于等于90显示a答:=IF(A1>=100,"A",IF(A1>=90,"B",IF(A1>=80,"C",IF(A1>=70,"D",IF(A1>=60,"E","F")))通过IF函数嵌套,像剥洋葱一样逐层判断A1数值所在的区间,并返回对应的结果。大于等于100,返回“A”,大于等于90,返回“B”,大于等于80,返回“C”……这个公式的优点是易于理解,缺点是...
...b1=3 如何做到B1=0的时候.a1,a2,a3都等于0 .否则不变答:SUM(INDIRECT("$A$1:$A$"&countif(D1:D10,">0"))) 如何用函数实现? 我想知道的是如何用函数来实现,而是用筛选的方法。 问题同下:有一组数,A1:A9依次是61,50,31,60,63,70,71,72,80,如何快速的算出"小于60的有几个数","大于等于60,小于等于69的有几个数","大于等于70,小于等于79的有几个...
如何用excel中的if、or和and函数。如果平均分高于60且每科成绩都60以 ...答:"良好",IF(I3>=60,"合格","不合格")))选中J3:K3,下拉填充 k3中还可用如下公式之一 =IF(I3<60,"不合格",IF(I3<75,"合格",IF(I3<85,"良好",IF(I3<95,"优良","优秀")))=IF(I3="","",LOOKUP(I3,{0,60,75,85,95},{"不合格","合格","良好","优良","优秀"}))...
...大于90分的优秀,大于60小于90的及格,小于60的不及格答:输入 =IF(B4>=90,"优秀",IF(B4>=60,"及格","不及格"))或者 =IF(B4<60,"不及格",IF(B4<90,"及格","优秀"))