IF函数提示引用错误,是为什么?答:=IF(H5<=6,0.025,IF(AND(7>H5,H5<12),0.06,IF(AND(13>H5,H5<18),0.08,IF(H>=19,0.16)))主要是小于等于、大于小于的输入不规范。
EXECL里面的IF函数多个条件为什么老是错误,函数哪里错了,高手帮帮忙...答:写法错误,改成如下即可:=IF(J4>=60,"优异",IF(J4>=48,"优秀",IF(J4>=36,"良好",IF(J4>=24,"合格","不合格")))
EXCEL IF函数错误答:75;24,80;26,85;28,90;30,95;32,100},2,TRUE)),IF(D5="",0,VLOOKUP(D5,{0,50;14,60;16,65;18,70;20,75;22,80;24,85;26,90;28,95;30,100},2,TRUE)))公式应该还可以更简洁——数据每递减2分,结果就递减5分。但不想费神了,直接拿去用吧 ——IF函数嵌套不能超过7层 ...