Personal tax calculator

1. Usage scenarios

This example describes how to calculate a personal income tax in YIDA.

2. Implement functions

2.1 Create a page

2.2 Formula configuration

(1) the amount of old personal income tax paid

{"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) amount of new personal income tax

{"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) compared with the past, how much tax was paid less each month

{"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) compared with the past, how much tax was paid less each year

{"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) salary received in the past

{"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) wages received now

{"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. Achieve results

4. Try it online

示例中心 | 开发者赋能平台

AI智能体时代，全新宜搭。业务创新，一搭就行。

https://www.aliwork.com/o/coc?tplUuid=TPL_AIN3G76XE1GHJRDRJ5G6&from=yuque_subject