Excel if的公式答:5 月出勤 6月出勤 保育费 G2=if(A2>=15,71,if(a2<=0,0,35))+if(B2>=15,71,if(B2<=0,0,35))+if(C2>=15,71,if(C2<=0,0,35))+if(D2>=15,71,if(D2<=0,0,35))+if(E2>=15,71,if(E2<=0,0,35))+if(F2>=15,71,if(F2<=0,0,35))...
求EXCEL单元格多条件函数答:在B2中输入:=IF(AND(B1>=1,B1<50),5,IF(AND(B1>=50,B1<100),10,IF(AND(B1>=100,B1<200),15,IF(AND(B1>=200,B1<300),20,IF(AND(B1>=300,B1<400),25,IF(AND(B1>=400,B1<500),30,IF(AND(B1>=500,B1<600),35,IF(AND(B1>=600,B1<700),40,IF(AND(B1>=700,B1<...