香奈兒 追問

2021-12-14 09:40

在Excel設置公式，合伙企業的經營所得五級超額累計的稅率和計算稅額。

海棠老師 解答

2021-12-14 10:23

參考一下這個
B1單元格寫入公式
=IF(A1="","",IF(A1<=11500,A1*0.085,IF(A1<=12900,(A1-11500)*0.085+27152.78,(A1-12900)*0.1445+30954.17)))
或
=IF(A1="","",IF(A1>12900,(A1-12900)*0.1445+30954.17,IF(A1>11500,(A1-11500)*0.085+27152.78,A1*0.085)))