- 相關(guān)推薦
excel 函數(shù)關(guān)于年終獎(jiǎng)個(gè)人所得稅計(jì)算的問題
這個(gè)公式能詳細(xì)解釋下嗎？我研究了半天都知道怎么算出的那個(gè)數(shù)字。請(qǐng)大家?guī)蛶臀遥?ROUND(IF((O8+P8-(3500-R8))/12<=0,0,IF((O8+P8-(3500-R8))/12<=1500,((O8+P8-(3500-R8)))/12*3%,IF((O8+P8-(3500-R8))/12<=4500,((O8+P8-(3500-R8)))/12*10%-105,IF((O8+P8-(3500-R8))/12<=9000,((O8+P8-(3500-R8)))/12*20%-555,IF((O8+P8-(3500-R8))/12<=35000,((O8+P8-(3500-R8)))/12*25%-1005,IF((O8+P8-(3500-R8))/12<=55000,(((O8+P8-(3500-R8)))/12*30%-2755),IF((O8+P8-(3500-R8))/12<=80000,((O8+P8-(3500-R8)))/12*35%-5505,((O8+P8-(3500-R8)))/12*45%-13505)))))))*12,2)
【excel 函數(shù)年終獎(jiǎng)個(gè)人所得稅計(jì)算的問題】相關(guān)文章：
年終獎(jiǎng)個(gè)人所得稅怎么計(jì)算？08-04
Excel高手教你round函數(shù)的使用方法03-07
股票個(gè)人所得稅計(jì)算方法06-06
月工資1000元，年終獎(jiǎng)金2500元需要交納年終獎(jiǎng)個(gè)人所得稅嗎？03-23
excel制作表格的步驟教程04-03
全年一次性獎(jiǎng)金個(gè)人所得稅計(jì)算器01-28
兩步計(jì)算的實(shí)際問題評(píng)課稿06-02