EXCEL 表格里关于IF函数的问题答:=IF(I3>89,"A",IF(I3>80,"B",IF(I3>70,"C",IF(I3>=60,"D",IF(I3<60,"F","")))你那问题里还有等于 80 70 60 几个的级别,自己可以修改下
电子表格中if函数怎么包含十种情况?答:=LOOKUP(A1,{1,2,3,4,5,6,7,8,9,10},{"我","们","的","爱","过","了","就","不","再","来"})
如果用IF函数计算出个人所得税答:假设A1单元格是要计算税金的工资数,B1单元格为税率,C1单元格为扣除数,D1单元格为应交税金税率的公式为:(IF(AND(A1>0,A1<=500),5%,IF(AND(A1>500,A1<=2000),10%,IF(AND(A1>2000,A1<=5000),15%,IF(AND(A1>5000,A1<=20000),20%,IF(AND(A1>20000,A1<=40000),25%。IF(AND(A1>...
电子表格if函数公式答:在A3处输入=if(A1 A2=3,'1','0','')这样输入就得了,意思也就是A1 A2=3时,A3为1,否则为0,如果是空时就为空。按照输入就得了 ,如果当A1和A3没数时可以多用几个if,表达如下:=if((if(A1,'A1','',))(if(A2,'A2','',))=3,'1','0','')