Excel2010求工资表公式答:1、=IF(C2="保安",保安基本工资/30*E2,IF(C2="服务",服务基本工资/30*E2,IF(C2="收银",收银基本工资/30*E2)))2、同上 3、=IF(DATEDIF(D2,TODAY(),"m")>12,100,IF(DATEDIF(D2,TODAY(),"m")=12,70,IF(DATEDIF(D2,TODAY(),"m")>=6,30,0)))
关于Excel根据应发工资如何计算缴纳的个税,请写出公式(IF函数)_百度...答:假如A列为工资,A2向下开始为工资数值,则B2输入公式如下,然后向下拉。=IF(A2>80000,A2*0.45,IF(AND(A2<=80000,A2>55000),A2*0.35,IF(AND(A2<=55000,A2>35000),A2*0.3,IF(AND(A2>9000,A2<=35000),A2*0.25,IF(AND(A2>4500,A2<=9000),A2*0.2,IF(AND(A2>1500,A2<=4500),A2...