excel里计算个人税：500以下的交5%，500以上至2000的交10%，2000以上至5000以下的交15%.if函数应该怎么写
发布网友
共3个回答
热心网友
如果数据在A1中，那么表达式为
=IF(A1<500,A1*5%,IF(A1<2000,A1*10%,IF(A1<5000,A1*15%)))
热心网友
=IF(A1<=500,A1*0.05,IF(A1<=2000,A1*0.1,IF(A1<=5000,A1*0.15,超过5000)))
热心网友
=if((工资-2000)<500,0.05,if((工资-2000)<2000,0.1,if((工资-2000)<5000,0.15,"超过5000"))))
热心网友
如果数据在A1中，那么表达式为
=IF(A1<500,A1*5%,IF(A1<2000,A1*10%,IF(A1<5000,A1*15%)))
热心网友
=IF(A1<=500,A1*0.05,IF(A1<=2000,A1*0.1,IF(A1<=5000,A1*0.15,超过5000)))
热心网友
=if((工资-2000)<500,0.05,if((工资-2000)<2000,0.1,if((工资-2000)<5000,0.15,"超过5000"))))
