اخر تعديل لشرائح الدخل القانون 7 لسنة 2024
20 الف اعفاء شخصي
40 الف شريحه صفرية
------------------
جميع معادلات شرائح الدخل من 2020 الى اخر مشروع تعديل 2024
https://www.youtube.com/watch?v=1clbGjL_gsg
-----------------
معادلة الاكسل للشرائح قانون 7 لسنة 2024
------------------
معادلة الاكسل للشرائح قانون 7 لسنة 2024
=IF(B1<=40000;0;
IF(B1<=55000;(B1-40000)*10%;
IF(B1<=70000;(B1-55000)*15%+1500;
IF(B1<=200000;(B1-70000)*20%+1500+2250;
IF(B1<=400000;(B1-200000)*22.5%+1500+2250+26000;
IF(B1<=600000;(B1-400000)*25%+1500+2250+26000+45000;
IF(AND(B1>600000;B1<=1200000);(B1-400000)*25%+1500+2250+26000+45000
+IFERROR(LOOKUP(B1;{600001;700001;800001;900001};{4000;6750;10250;15250});0);IF(B1>1200000;((B1-1200000)*27.5%)+300000;0)
)))))))
أو
=+ROUND(IF((E15*12)<=600000,
IF(E15*12<=40000,0,
IF(E15*12<=55000,(E15*12-40000)*10%,
IF(E15*12<=70000,(E15*12-55000)*15%+15000*10%,
IF(E15*12<=200000,(E15*12-70000)*20%+15000*15%+15000*10%,
IF(E15*12<=400000,(E15*12-200000)*22.5%+130000*20%+15000*15%+15000*10%,
IF(E15*12>400000,(E15*12-400000)*25%+200000*22.5%+130000*20%+15000*15%+15000*10%,0)))))),
IF((E15*12)<=700000,
IF(E15*12<=55000,(E15*12)*10%,
IF(E15*12<=70000,(E15*12-55000)*15%+55000*10%,
IF(E15*12<=200000,(E15*12-70000)*20%+15000*15%+55000*10%,
IF(E15*12<=400000,(E15*12-200000)*22.5%+130000*20%+15000*15%+55000*10%,
IF(E15*12>400000,(E15*12-400000)*25%+200000*22.5%+130000*20%+15000*15%+55000*10%,0))))),
IF((E15*12)<=800000,
IF(E15*12<=70000,(E15*12)*15%,
IF(E15*12<=200000,(E15*12-70000)*20%+70000*15%,
IF(E15*12<=400000,(E15*12-200000)*22.5%+130000*20%+70000*15%,
IF(E15*12>400000,(E15*12-400000)*25%+200000*22.5%+130000*20%+70000*15%,0)))),
IF((E15*12)<=900000,
IF(E15*12<=200000,(E15*12)*20%,
IF(E15*12<=400000,(E15*12-200000)*22.5%+200000*20%,
IF(E15*12>400000,(E15*12-400000)*25%+200000*22.5%+200000*20%,0))),
IF((E15*12)<=1200000,
IF(E15*12<=400000,(E15*12)*22.5%,
IF(E15*12>400000,(E15*12-130000)*25%+400000*22.5%)),
IF(E15*12>1200000,(E15*12-1200000)*27.5%+1200000*25%,0))))))/12,0)
-------------------------------------
معادلة شرائح قانون 175 لسنة 2023
=+ROUND(IF((D15*12)<=600000,
IF(D15*12<=30000,0,
IF(D15*12<=45000,(D15*12-30000)*10%,
IF(D15*12<=60000,(D15*12-45000)*15%+15000*10%,
IF(D15*12<=200000,(D15*12-60000)*20%+15000*15%+15000*10%,
IF(D15*12<=400000,(D15*12-200000)*22.5%+140000*20%+15000*15%+15000*10%,
IF(D15*12>400000,(D15*12-400000)*25%+200000*22.5%+140000*20%+15000*15%+15000*10%,0)))))),
IF((D15*12)<=700000,
IF(D15*12<=45000,(D15*12)*10%,
IF(D15*12<=60000,(D15*12-45000)*15%+45000*10%,
IF(D15*12<=200000,(D15*12-60000)*20%+15000*15%+45000*10%,
IF(D15*12<=400000,(D15*12-200000)*22.5%+140000*20%+15000*15%+45000*10%,
IF(D15*12>400000,(D15*12-400000)*25%+200000*22.5%+140000*20%+15000*15%+45000*10%,0))))),
IF((D15*12)<=800000,
IF(D15*12<=60000,(D15*12)*15%,
IF(D15*12<=200000,(D15*12-60000)*20%+60000*15%,
IF(D15*12<=400000,(D15*12-200000)*22.5%+140000*20%+60000*15%,
IF(D15*12>400000,(D15*12-400000)*25%+200000*22.5%+140000*20%+60000*15%,0)))),
IF((D15*12)<=900000,
IF(D15*12<=200000,(D15*12)*20%,
IF(D15*12<=400000,(D15*12-200000)*22.5%+200000*20%,
IF(D15*12>400000,(D15*12-400000)*25%+200000*22.5%+200000*20%,0))),
IF((D15*12)<=1200000,
IF(D15*12<=400000,(D15*12)*22.5%,
IF(D15*12>400000,(D15*12-400000)*25%+400000*22.5%)),
IF(D15*12>1200000,(D15*12-1200000)*27.5%+1200000*25%,0))))))/12,0)
--------------------------------------
للمزيد
ليست هناك تعليقات:
إرسال تعليق