當(dāng)前位置:財(cái)稅問(wèn)題 >
實(shí)務(wù)
問(wèn)題已解決
您好,我想要一份工資薪金個(gè)人所得稅帶公式計(jì)算表,請(qǐng)問(wèn)有嗎
溫馨提示:如果以上題目與您遇到的情況不符,可直接提問(wèn),隨時(shí)問(wèn)隨時(shí)答
速問(wèn)速答同學(xué)您好
假設(shè)B列是稅前工資,C列是專項(xiàng)扣除,D是專項(xiàng)附加扣除,E是其他扣除
應(yīng)納稅是【=ROUND(MAX((B2-C2-D2-E2-5000)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,210,1410,2660,4410,7160,15160},0),2)】
2023 07/01 22:48
閱讀 495