跳到主要内容

实用工具 - 个税计算器

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. 在线试玩

Copyright © 2024钉钉(中国)信息技术有限公司和/或其关联公司浙ICP备18037475号-4