معادلات اكسيل حساب ضريبة كسب العمل لعام ٢٠٢٣

معادلة EXCEL حساب الضريبة بدء 1-2023 الى 6-2023

=IF(A1<=21000,0, IF(A1<=30000,(A1-21000)*2.5%, IF(A1<=45000,(A1-30000)*10%+225, IF(A1<=60000,(A1-45000)*15%+225+1500, IF(A1<=200000,(A1-60000)*20%+225+1500+2250, IF(A1<=400000,(A1-200000)*22.5%+225+1500+2250+28000, IF(A1<=600000,(A1-400000)*25%+225+1500+2250+28000+45000, IF(AND(A1>600000,A1<=1200000),(A1-400000)*25%+225+1500+2250+28000+45000+IFERROR(LOOKUP(A1,{600001;700001;800001;900001},{525;2775;5025;8025}),0), IF(A1>1200000,((A1-1200000)*27.5%)+300000,0) ))))))))

معادلة EXCEL حساب الضريبة بدء 7-2023 الى 10-2023

=IF(A1<=21000,0, IF(A1<=30000,(A1-21000)*2.5%, IF(A1<=45000,(A1-30000)*10%+225, IF(A1<=60000,(A1-45000)*15%+225+1500, IF(A1<=200000,(A1-60000)*20%+225+1500+2250, IF(A1<=400000,(A1-200000)*22.5%+225+1500+2250+28000, IF(A1<=600000,(A1-400000)*25%+225+1500+2250+28000+45000, IF(AND(A1>600000,A1<=1200000),(A1-400000)*25%+225+1500+2250+28000+45000+IFERROR(LOOKUP(A1,{600001;700001;800001;900001},{525;2775;5025;8025}),0), IF(A1>1200000,((A1-1200000)*27.5%)+300000,0) ))))))))

معادلة EXCEL حساب الضريبة بدء 11-2023 الى 12-2023

=IF(A1<=30000,0, IF(A1<=45000,(A1-30000)*10%, IF(A1<=60000,1500+(A1-45000)*15%, IF(A1<=200000,1500+2250+(A1-60000)*20%, IF(A1<=400000,1500+2250+28000+(A1-200000)*22.5%, IF(A1<=600000,1500+2250+28000+45000+(A1-400000)*25%, IF(A1<=700000,4500+2250+28000+45000+(A1-400000)*25%, IF(A1<=800000,9000+28000+45000+(A1-400000)*25%, IF(A1<=900000,40000+45000+(A1-400000)*25%, IF(A1<=1200000,90000+(A1-400000)*25%, IF(A1>1200000,300000+(A1-1200000)*27.5%,0)))))))))))