excel表格使用if函数问题,显示您输入的公式错误,如果您输入的不是公式...答:B1=IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",IF(A1=5,"E",IF(A1=6,"F",IF(A1=7,"G",IF(A1=8,"H",C1)))C1=IF(A1=9,"I",IF(A1=10,"J",IF(A1=11,"K",IF(A1=12,"L",IF(A1=13,"M",IF(A1=14,"N",IF(A1=15,"O",IF(A1=16,"P",D...
excel函数每次输入都显示“请在第一个字符前输入单引号”,输了之后还...答:因为你这个公式写错了,if()可以理解成如果,如果条件成立,显示第一个逗号后的结果,不成立显示第二个逗号后的结果。所以IF(,,)里面只能有两个逗号。所以你的公式需要套用IF,帮你改一下:=IF(J9>=90,"优",IF(J9>=80,"良",IF(J9>=70,"中",IF(J9>=60,"及格","不及格")))也可以用l...