个税计算器
1. 使用场景
本例介绍如何在宜搭中计算个税。
2. 实现功能
2.1 创建页面
2.2 公式配置
（1）旧个税缴纳额
{"text":"IF(LE(🌞 应税工资（即扣除五险后的工资）-3500,0),0,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,0),LE(🌞 应税工资（即扣除五险后的工资）-3500,1500)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.03,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,1500),LE(🌞 应税工资（即扣除五险后的工资）-3500,4500)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.1-105,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,4500),LE(🌞 应税工资（即扣除五险后的工资）-3500,9000)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.2-555,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,9000),LE(🌞 应税工资（即扣除五险后的工资）-3500,35000)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.25-1005,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,35000),LE(🌞 应税工资（即扣除五险后的工资）-3500,55000)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.3-2775,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,55000),LE(🌞 应税工资（即扣除五险后的工资）-3500,80000)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.35-5505,IF(GT(🌞 应税工资（即扣除五险后的工资）-3500,80000),(🌞 应税工资（即扣除五险后的工资）-3500)*0.45-13505,\"\"))))))))","marks":[{"from":{"line":0,"ch":6,"sticky":null},"to":{"line":0,"ch":26,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":47,"sticky":null},"to":{"line":0,"ch":67,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":79,"sticky":null},"to":{"line":0,"ch":99,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":113,"sticky":null},"to":{"line":0,"ch":133,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":155,"sticky":null},"to":{"line":0,"ch":175,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":190,"sticky":null},"to":{"line":0,"ch":210,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":224,"sticky":null},"to":{"line":0,"ch":244,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":269,"sticky":null},"to":{"line":0,"ch":289,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":304,"sticky":null},"to":{"line":0,"ch":324,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":338,"sticky":null},"to":{"line":0,"ch":358,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":383,"sticky":null},"to":{"line":0,"ch":403,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":418,"sticky":null},"to":{"line":0,"ch":438,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":453,"sticky":null},"to":{"line":0,"ch":473,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":500,"sticky":null},"to":{"line":0,"ch":520,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":536,"sticky":null},"to":{"line":0,"ch":556,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":571,"sticky":null},"to":{"line":0,"ch":591,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":617,"sticky":null},"to":{"line":0,"ch":637,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":653,"sticky":null},"to":{"line":0,"ch":673,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":688,"sticky":null},"to":{"line":0,"ch":708,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":731,"sticky":null},"to":{"line":0,"ch":751,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":765,"sticky":null},"to":{"line":0,"ch":785,"sticky":null},"value":"textField_ksxylrvb","invalid":false}],"isCmData":true}
（2）新个税缴纳额
{"text":"IF(LE(🌞 应税工资（即扣除五险后的工资）-5000,0),0,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,0),LE(🌞 应税工资（即扣除五险后的工资）-5000,3000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.03,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,3000),LE(🌞 应税工资（即扣除五险后的工资）-5000,12000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.1-210,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,12000),LE(🌞 应税工资（即扣除五险后的工资）-5000,25000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.2-1410,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,25000),LE(🌞 应税工资（即扣除五险后的工资）-5000,35000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.25-2660,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,35000),LE(🌞 应税工资（即扣除五险后的工资）-5000,55000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.3-4410,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,55000),LE(🌞 应税工资（即扣除五险后的工资）-5000,80000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.35-7160,IF(GT(🌞 应税工资（即扣除五险后的工资）-5000,80000),(🌞 应税工资（即扣除五险后的工资）-5000)*0.45-15160,\"\"))))))))","marks":[{"from":{"line":0,"ch":6,"sticky":null},"to":{"line":0,"ch":26,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":47,"sticky":null},"to":{"line":0,"ch":67,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":79,"sticky":null},"to":{"line":0,"ch":99,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":113,"sticky":null},"to":{"line":0,"ch":133,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":155,"sticky":null},"to":{"line":0,"ch":175,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":190,"sticky":null},"to":{"line":0,"ch":210,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":225,"sticky":null},"to":{"line":0,"ch":245,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":270,"sticky":null},"to":{"line":0,"ch":290,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":306,"sticky":null},"to":{"line":0,"ch":326,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":341,"sticky":null},"to":{"line":0,"ch":361,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":387,"sticky":null},"to":{"line":0,"ch":407,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":423,"sticky":null},"to":{"line":0,"ch":443,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":458,"sticky":null},"to":{"line":0,"ch":478,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":505,"sticky":null},"to":{"line":0,"ch":525,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":541,"sticky":null},"to":{"line":0,"ch":561,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":576,"sticky":null},"to":{"line":0,"ch":596,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":622,"sticky":null},"to":{"line":0,"ch":642,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":658,"sticky":null},"to":{"line":0,"ch":678,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":693,"sticky":null},"to":{"line":0,"ch":713,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":736,"sticky":null},"to":{"line":0,"ch":756,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":770,"sticky":null},"to":{"line":0,"ch":790,"sticky":null},"value":"textField_ksxylrvb","invalid":false}],"isCmData":true}
（3）对比过去，每个月少交了多少个税
{"text":"(IF(LE(🌞 应税工资（即扣除五险后的工资）-3500,0),0,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,0),LE(🌞 应税工资（即扣除五险后的工资）-3500,1500)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.03,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,1500),LE(🌞 应税工资（即扣除五险后的工资）-3500,4500)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.1-105,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,4500),LE(🌞 应税工资（即扣除五险后的工资）-3500,9000)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.2-555,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,9000),LE(🌞 应税工资（即扣除五险后的工资）-3500,35000)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.25-1005,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,35000),LE(🌞 应税工资（即扣除五险后的工资）-3500,55000)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.3-2775,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-3500,55000),LE(🌞 应税工资（即扣除五险后的工资）-3500,80000)),(🌞 应税工资（即扣除五险后的工资）-3500)*0.35-5505,IF(GT(🌞 应税工资（即扣除五险后的工资）-3500,80000),(🌞 应税工资（即扣除五险后的工资）-3500)*0.45-13505,\"\")))))))))-(IF(LE(🌞 应税工资（即扣除五险后的工资）-5000,0),0,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,0),LE(🌞 应税工资（即扣除五险后的工资）-5000,3000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.03,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,3000),LE(🌞 应税工资（即扣除五险后的工资）-5000,12000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.1-210,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,12000),LE(🌞 应税工资（即扣除五险后的工资）-5000,25000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.2-1410,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,25000),LE(🌞 应税工资（即扣除五险后的工资）-5000,35000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.25-2660,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,35000),LE(🌞 应税工资（即扣除五险后的工资）-5000,55000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.3-4410,IF(AND(GT(🌞 应税工资（即扣除五险后的工资）-5000,55000),LE(🌞 应税工资（即扣除五险后的工资）-5000,80000)),(🌞 应税工资（即扣除五险后的工资）-5000)*0.35-7160,IF(GT(🌞 应税工资（即扣除五险后的工资）-5000,80000),(🌞 应税工资（即扣除五险后的工资）-5000)*0.45-15160,\"\")))))))))","marks":[{"from":{"line":0,"ch":7,"sticky":null},"to":{"line":0,"ch":27,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":48,"sticky":null},"to":{"line":0,"ch":68,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":80,"sticky":null},"to":{"line":0,"ch":100,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":114,"sticky":null},"to":{"line":0,"ch":134,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":156,"sticky":null},"to":{"line":0,"ch":176,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":191,"sticky":null},"to":{"line":0,"ch":211,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":225,"sticky":null},"to":{"line":0,"ch":245,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":270,"sticky":null},"to":{"line":0,"ch":290,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":305,"sticky":null},"to":{"line":0,"ch":325,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":339,"sticky":null},"to":{"line":0,"ch":359,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":384,"sticky":null},"to":{"line":0,"ch":404,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":419,"sticky":null},"to":{"line":0,"ch":439,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":454,"sticky":null},"to":{"line":0,"ch":474,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":501,"sticky":null},"to":{"line":0,"ch":521,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":537,"sticky":null},"to":{"line":0,"ch":557,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":572,"sticky":null},"to":{"line":0,"ch":592,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":618,"sticky":null},"to":{"line":0,"ch":638,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":654,"sticky":null},"to":{"line":0,"ch":674,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":689,"sticky":null},"to":{"line":0,"ch":709,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":732,"sticky":null},"to":{"line":0,"ch":752,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":766,"sticky":null},"to":{"line":0,"ch":786,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":823,"sticky":null},"to":{"line":0,"ch":843,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":864,"sticky":null},"to":{"line":0,"ch":884,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":896,"sticky":null},"to":{"line":0,"ch":916,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":930,"sticky":null},"to":{"line":0,"ch":950,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":972,"sticky":null},"to":{"line":0,"ch":992,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1007,"sticky":null},"to":{"line":0,"ch":1027,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1042,"sticky":null},"to":{"line":0,"ch":1062,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1087,"sticky":null},"to":{"line":0,"ch":1107,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1123,"sticky":null},"to":{"line":0,"ch":1143,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1158,"sticky":null},"to":{"line":0,"ch":1178,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1204,"sticky":null},"to":{"line":0,"ch":1224,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1240,"sticky":null},"to":{"line":0,"ch":1260,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1275,"sticky":null},"to":{"line":0,"ch":1295,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1322,"sticky":null},"to":{"line":0,"ch":1342,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1358,"sticky":null},"to":{"line":0,"ch":1378,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1393,"sticky":null},"to":{"line":0,"ch":1413,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1439,"sticky":null},"to":{"line":0,"ch":1459,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1475,"sticky":null},"to":{"line":0,"ch":1495,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1510,"sticky":null},"to":{"line":0,"ch":1530,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1553,"sticky":null},"to":{"line":0,"ch":1573,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":1587,"sticky":null},"to":{"line":0,"ch":1607,"sticky":null},"value":"textField_ksxylrvb","invalid":false}],"isCmData":true}
（4）对比过去，每年少交了多少个税
{"text":"✈ 对比过去，每个月少交了多少个税？*12","marks":[{"from":{"line":0,"ch":0,"sticky":null},"to":{"line":0,"ch":20,"sticky":null},"value":"textField_ksxylrvo","invalid":false}],"isCmData":true}
（5）过去到手工资
{"text":"🌞 应税工资（即扣除五险后的工资）-≣ 旧个税缴纳额","marks":[{"from":{"line":0,"ch":0,"sticky":null},"to":{"line":0,"ch":20,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":21,"sticky":null},"to":{"line":0,"ch":31,"sticky":null},"value":"textField_ksxylrvd","invalid":false}],"isCmData":true}
（6）现在到手工资
{"text":"🌞 应税工资（即扣除五险后的工资）-≣ 新个税缴纳额","marks":[{"from":{"line":0,"ch":0,"sticky":null},"to":{"line":0,"ch":20,"sticky":null},"value":"textField_ksxylrvb","invalid":false},{"from":{"line":0,"ch":21,"sticky":null},"to":{"line":0,"ch":31,"sticky":null},"value":"textField_ksxylrvp","invalid":false}],"isCmData":true}
3. 实现效果
4. 在线试玩
本文档对您是否有帮助？