=IF(O7>80000000, O7*0.35-9850000,IF(O7>52000000, O7*0.3-5850000,IF(O7>32000000, O7*0.25-3250000,IF(O7>18000000,O7*0.2-1650000,IF(O7>10000000,O7*0.15-750000,IF(O7>5000000, O7*0.1-250000,IF(O7>0,O7*0.05,0)))))))
Ban phai nho tru truoc khi lay lam thu nhap chiu thue
- BHXH, BHYT, BHTN
- Giam tru gia canh: cho ban than nguoi nop thue 4 tr/thang; nguoi phu thuoc 1,6 tr/thang x so nguoi giam tru
- Dong gop tu thien nhan dao (neu co chung tu)
Các bạn qua link sau để tham khảo cách tính bằng excel: Tải về
No comments:
Post a Comment