範文齋

位置:首頁 > 職場範文 > 職場百科

excel 函數關於年終獎個人所得税計算的問題

這個公式能詳細解釋下嗎?我研究了半天都知道怎麼算出的`那個數字。請大家幫幫我!=ROUND(IF((O8+P8-(3500-R8))&#47;12<=0,0,IF((O8+P8-(3500-R8))&#47;12<=1500,((O8+P8-(3500-R8)))&#47;12*3%,IF((O8+P8-(3500-R8))&#47;12<=4500,((O8+P8-(3500-R8)))&#47;12*10%-105,IF((O8+P8-(3500-R8))&#47;12<=9000,((O8+P8-(3500-R8)))&#47;12*20%-555,IF((O8+P8-(3500-R8))&#47;12<=35000,((O8+P8-(3500-R8)))&#47;12*25%-1005,IF((O8+P8-(3500-R8))&#47;12<=55000,(((O8+P8-(3500-R8)))&#47;12*30%-2755),IF((O8+P8-(3500-R8))&#47;12<=80000,((O8+P8-(3500-R8)))&#47;12*35%-5505,((O8+P8-(3500-R8)))&#47;12*45%-13505)))))))*12,2)

excel 函數關於年終獎個人所得税計算的問題