我的公式那个地方弄错了,D3原有数据为91
=IF(B3<45,"E",IF(45<=B3<60,"D",IF(75<B3<=60,"C",IF(85<B3<=75,"B","A"))))
得到的结果为不是“A”,而是“0",是哪个地方弄错了
1.
判断不能写成45=45,所以第二个if就不用判断45<=B3。
您好,这个问题是我多年来一直没有解决的,也很想弄懂它。
您能否在电子表格中实际写一个完整计算公式吗(您的qq?)
我的QQ:249942072
我还是没有弄清楚其中的关系
先谢谢!
我没有QQ号。
=IF(B3<45,"E",IF(45<=B3<60,"D",IF(75<B3<=60,"C",IF(85<B3<=75,"B","A"))))
先给你解释一遍上面这个公式的计算过程:
首先它会将B3的值与45比较,假如B3的值是50,那么这个公式就变成
=IF(False,"E",IF(45<=B3<60,"D",IF(75<B3<=60,"C",IF(85<B3<=75,"B","A"))))
因为是False,所以这个公式的值就和"E"无关,式子变成
=IF(45<=B3<60,"D",IF(75<B3<=60,"C",IF(85<B3<=75,"B","A")))
它将B3的值与45比较,结果是True,所以公式变成
=IF(Ture<60,"D",IF(75<B3<=60,"C",IF(85<B3<=75,"B","A")))
因为Ture是逻辑值,所以Ture<60的结果是False,公式变成:
=IF(False,"D",IF(75<B3<=60,"C",IF(85<B3<=75,"B","A")))
因为是False,所以这个公式的值就和"D"无关,式子变成
=IF(75<B3<=60,"C",IF(85<B3<=75,"B","A"))
它将B3的值与75比较,结果是False,所以公式变成:
=IF(False<=60,"C",IF(85<B3<=75,"B","A"))
因为False是逻辑值,所以False<=60的结果是False,公式变成:
=IF(False,"C",IF(85<B3<=75,"B","A"))
因为是False,所以这个公式的值就和"C"无关,式子变成
=IF(85<B3<=75,"B","A")
它将B3的值与85比较,结果是False,所以公式变成:
=IF(False<=75,"B","A"))
因为False是逻辑值,所以False<=75的结果是False,公式变成:
=IF(False,"B","A"))
因为是False,所以这个公式的值就和"B"无关,式子的值就是"A"
所以说,判断不能写成45<=B3<60这种形式。
再给你说说下面公式的计算过程
=if(A1<60,"D",if(A1<80,"C",if(A1<90,"B","A")))
将A1单元格的值与60比较,比如A1单元的值是75,得到False,公式变成:
=if(False,"D",if(A1<80,"C",if(A1<90,"B","A")))
因为是False,所以与"D"无关,公式变成:
=if(A1<80,"C",if(A1<90,"B","A"))
将A1与80比较,得到True,公式变成:
=if(True,"C",if(A1<90,"B","A"))
因为是True,所以就与后面的if函数无关,值就是"C"
按照你给出的参数,公式如下:
=IF(B3<45,"E",IF(B3<60,"D",IF(B3<75,"C",IF(B3<85,"B","A"))))
你把这个公式放到C3单元格中,给B3不同的值,看看C3的值是什么。
还有,判断句75<B3<=60是不可能成立的,应写成60<=B3<75,同样,85<B3<=75也不对。
如前面所述,在Excel中,60<=B3<75用AND(60<=B3,B3<75)来表示。