معادلة اكسل كسب العمل بداية من 1 يوليو حسب التعديل الجديد
في قانون الدخل بالقانون 30 لسنة 2023
-------------------=ROUND(IF((D13*12)<=600000,IF(D13*12<=21000,0,IF(D13*12<=30000,(D13*12-21000)*2.5%,IF(D13*12<=45000,(D13*12-30000)*10%+9000*2.5%,IF(D13*12<=60000,(D13*12-45000)*15%+15000*10%+9000*2.5%,IF(D13*12<=200000,(D13*12-60000)*20%+15000*15%+15000*10%+9000*2.5%,IF(D13*12<=400000,(D13*12-200000)*22.5%+140000*20%+15000*15%+15000*10%+9000*2.5%,IF(D13*12>400000,(D13*12-400000)*25%+200000*22.5%+140000*20%+15000*15%+15000*10%+9000*2.5%,0))))))),IF((D13*12)<=700000,IF(D13*12<=30000,(D13*12)*2.5%,IF(D13*12<=45000,(D13*12-30000)*10%+30000*2.5%,IF(D13*12<=60000,(D13*12-45000)*15%+15000*10%+30000*2.5%,IF(D13*12<=200000,(D13*12-60000)*20%+15000*15%+15000*10%+30000*2.5%,IF(D13*12<=400000,(D13*12-200000)*22.5%+140000*20%+15000*15%+15000*10%+30000*2.5%,IF(D13*12>400000,(D13*12-400000)*25%+200000*22.5%+140000*20%+15000*15%+15000*10%+30000*2.5%,0)))))),IF((D13*12)<=800000,IF(D13*12<=45000,(D13*12)*10%,IF(D13*12<=60000,(D13*12-45000)*15%+45000*10%,IF(D13*12<=200000,(D13*12-60000)*20%+15000*15%+45000*10%,IF(D13*12<=400000,(D13*12-200000)*22.5%+140000*20%+15000*15%+45000*10%,IF(D13*12>400000,(D13*12-400000)*25%+200000*22.5%+140000*20%+15000*15%+45000*10%,0))))),IF((D13*12)<=900000,IF(D13*12<=60000,(D13*12)*15%,IF(D13*12<=200000,(D13*12-60000)*20%+60000*15%,IF(D13*12<=400000,(D13*12-200000)*22.5%+140000*20%+60000*15%,IF(D13*12>400000,(D13*12-400000)*25%+200000*22.5%+140000*20%+60000*15%,0)))),IF((D13*12)<=1200000,IF(D13*12<=200000,(D13*12)*20%,IF(D13*12<=400000,(D13*12-200000)*22.5%+200000*20%,IF(D13*12>400000,(D13*12-400000)*25%+200000*22.5%+200000*20%,0))),IF((D13*12)>1200000,IF(D13*12<=1200000,(D13*12)*25%,IF(D13*12>=1200000,(D13*12-1200000)*27.5%+1200000*25%,0))))))))/12,0)-----------
شيت اكسل جاهز
https://drive.google.com/file/d/1NCrt8tFba1CYHdT9E5TFrD74XWLob70g/view?usp=sharing
-----------
مشكور
ردحذف