
=ROUND(MAX((G4-H4-I4-5000)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,210,1410,2660,4410,7160,15160},0),2),這個(gè)公式我看不懂,我怎么引用到我的工資表里
答: 可以幫助你解決這個(gè)問(wèn)題,這個(gè)是一個(gè)新的個(gè)稅公式
=ROUND(MAX((P5-5000)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,210,1410,2660,4410,7160,15160},0),2)像這種個(gè)稅的計(jì)算公式對(duì)嗎
答: 您好:對(duì)的,這是之前不是累計(jì)專項(xiàng)扣除的個(gè)稅計(jì)算公式。
我是一名會(huì)計(jì),想問(wèn)一下考個(gè)網(wǎng)絡(luò)學(xué)歷有用嗎?
答: 眾所周知會(huì)計(jì)人如果要往上發(fā)展,是要不斷考證的
ROUND(MAX(應(yīng)付工資-5000-扣除項(xiàng))*(0.03,0.1,0.2,0.25,0.3,0.35,0.45)-(0.210,1410,2660,4410,7160,15160),0),2)
答: 你好! 可以的


L. 追問(wèn)
2018-10-19 14:52
江老師 解答
2018-10-19 14:52