على أحمد على
06-20-2023, 11:50 PM
Abdelaziz Kamal (https://web.facebook.com/groups/615485031889470/user/100012986717778/?__cft__[0]=AZUL237Ju4ImtiUrdEN5vY5bzgca0dhu7606fOE0RF8uPazSV INJXk99LL10oaTsPHvkL7f0Htb3MGXnhjwDf2igHcaeC3IG8Cm JjCBiwEFqcKwnKTrTIzr5yzj9cFAmpKg7axQ0vMMdEkMeo3ggK AYLJB1uUlm2B3B-Y9uKONZFPwy80um_f0RvufY2d3PWCpg&__tn__=%2CP-R)
معادلة اكسل كسب العمل بداية من 1 يوليو حسب التعديل الجديد في قانون الدخل بالقانون 30 لسن ة 2023
-------------------
=ROUND(IF((D11*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%+1500 0*10%+9000*2.5%,0))))))),IF((D11*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*1 2<=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%+1500 0*10%+30000*2.5%,0)))))),IF((D11*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(D1 3*12>400000,(D13*12-400000)*25%+200000*22.5%+140000*20%+15000*15%+4500 0*10%,0))))),IF((D11*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((D11*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((D11*1 2)>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/.../11Xeo4Ki8Joa3a_P5dj5.../view... (https://l.facebook.com/l.php?u=https%3A%2F%2Fdrive.google.com%2Ffile%2Fd% 2F11Xeo4Ki8Joa3a_P5dj5_68ghnsZRSC1Z%2Fview%3Fusp%3 Dsharing%26fbclid%3DIwAR3oRzzkGv1QR90PlPsu8O9e9aqK Svm4CAFUvDq0IiM4bN0Jx9f6xZ5p8Ks&h=AT3yI5mX6KiSVDucbDOsmrJoQ4YomFl3b0YcwW5_m_AcyP3e Oka8-s7tqO-bWuQAKClPBbi1_oQhFprpNey9U-YBCjvPs1n9TD591157O9sqHwSgl6sNsFjjR1BZReweZw&__tn__=-UK-R&c[0]=AT3Jv5ozXweKgCgAtwgG90pNsTyBsiUxNV6Tjvz7UrdI-fLAL0cTpe3C4ayl0i5ZLPU9iPhTzhNz_4nIrTYLYOPFvWuf5vq p08_zS-XcUqPHvvhK3Osc-Q5bXKoVM_YBcXqcNC6sGqsbzg-MoJfWsc-JKC3BU96N05uZLH9OKvX8Ds0VC0pr0I-7pFMwkHdBUKTGCN52-fA7knTVviVBPR7EaHE)
-----------
معادلة اكسل كسب العمل بداية من 1 يوليو حسب التعديل الجديد في قانون الدخل بالقانون 30 لسن ة 2023
-------------------
= الجولة (IF((D11*12)<=600000,IF(D13*12<=21000,0,IF(دي 13*12<=30000,(D13* 12-21000)*2.5%,IF( D13 * 12<=45000,(D13 *12-30000)*10%+9000*2.5%، IF(D13 * 12. <=60000,(D 13* 12-45000)*15%+15000*10%+ 9000*2.5%. IF(D13*. 12<=200000,(D1*12-60000)*20%+15000 15%+15000*10%+9000*2.5%,0)))))،IF(D11*12)<=700000,IF(D13*12<=30000,(D13* 12)*2.5%،IF(D 13 *12<=45000,(D13 *12-30000)*10%+30000*2.5% ,إذا(D13*13*12. <=60000، (D 13*12-45000)*15%+15000*10. ٪+30000 *2.5%,IF (D13*12 <=200000,(D13 *12-60000)*20%+15000 *15%+15% 5000*15%+15000*10%+30000*2.5%,0))))),IF(D11*12)<=800000,IF( D13*12<=45000,(D 13*12)*10%,IF(دي13*12< =60000,(D13*12-45000)*15%+45000*10%, IF(D13* 12<=200000)*12-600000)*20%,IF*D13*12=400000)*12<=400000*12-200)*22.5%+140000*20% IF (D13 *12<=200000*12-200000*20%+600*20%+IF(D13=400000,(D113*12-200000) 22.5%+140000*20%+6000*15%، IF(D13*12. >400000,(d13*12-400000)*25%+200000*22.5% +140000*20%+60000*15.0))))،IF(D11*12)<=1200000,IF(D13 *12)*12 )*25%,IF( D13*12>=1200000،(D13*12.12-1200000)*27.5%+1200000*25%,0))))))/12,0)
-----------
شيت اكسل جاهز
https://drive.google.com/.../11Xeo4Ki8Joa3a_P5dj5.../view... (https://drive.google.com/file/d/11Xeo4Ki8Joa3a_P5dj5_68ghnsZRSC1Z/view?usp=sharing&fbclid=IwAR1W044I5l3BEuWBB7Mu7SYHwHlNBAN7jrmsGdgfP x0CDZiwaf7NYMUs7uA)
-----------
معادلة اكسل كسب العمل بداية من 1 يوليو حسب التعديل الجديد في قانون الدخل بالقانون 30 لسن ة 2023
-------------------
=ROUND(IF((D11*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%+1500 0*10%+9000*2.5%,0))))))),IF((D11*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*1 2<=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%+1500 0*10%+30000*2.5%,0)))))),IF((D11*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(D1 3*12>400000,(D13*12-400000)*25%+200000*22.5%+140000*20%+15000*15%+4500 0*10%,0))))),IF((D11*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((D11*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((D11*1 2)>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/.../11Xeo4Ki8Joa3a_P5dj5.../view... (https://l.facebook.com/l.php?u=https%3A%2F%2Fdrive.google.com%2Ffile%2Fd% 2F11Xeo4Ki8Joa3a_P5dj5_68ghnsZRSC1Z%2Fview%3Fusp%3 Dsharing%26fbclid%3DIwAR3oRzzkGv1QR90PlPsu8O9e9aqK Svm4CAFUvDq0IiM4bN0Jx9f6xZ5p8Ks&h=AT3yI5mX6KiSVDucbDOsmrJoQ4YomFl3b0YcwW5_m_AcyP3e Oka8-s7tqO-bWuQAKClPBbi1_oQhFprpNey9U-YBCjvPs1n9TD591157O9sqHwSgl6sNsFjjR1BZReweZw&__tn__=-UK-R&c[0]=AT3Jv5ozXweKgCgAtwgG90pNsTyBsiUxNV6Tjvz7UrdI-fLAL0cTpe3C4ayl0i5ZLPU9iPhTzhNz_4nIrTYLYOPFvWuf5vq p08_zS-XcUqPHvvhK3Osc-Q5bXKoVM_YBcXqcNC6sGqsbzg-MoJfWsc-JKC3BU96N05uZLH9OKvX8Ds0VC0pr0I-7pFMwkHdBUKTGCN52-fA7knTVviVBPR7EaHE)
-----------
معادلة اكسل كسب العمل بداية من 1 يوليو حسب التعديل الجديد في قانون الدخل بالقانون 30 لسن ة 2023
-------------------
= الجولة (IF((D11*12)<=600000,IF(D13*12<=21000,0,IF(دي 13*12<=30000,(D13* 12-21000)*2.5%,IF( D13 * 12<=45000,(D13 *12-30000)*10%+9000*2.5%، IF(D13 * 12. <=60000,(D 13* 12-45000)*15%+15000*10%+ 9000*2.5%. IF(D13*. 12<=200000,(D1*12-60000)*20%+15000 15%+15000*10%+9000*2.5%,0)))))،IF(D11*12)<=700000,IF(D13*12<=30000,(D13* 12)*2.5%،IF(D 13 *12<=45000,(D13 *12-30000)*10%+30000*2.5% ,إذا(D13*13*12. <=60000، (D 13*12-45000)*15%+15000*10. ٪+30000 *2.5%,IF (D13*12 <=200000,(D13 *12-60000)*20%+15000 *15%+15% 5000*15%+15000*10%+30000*2.5%,0))))),IF(D11*12)<=800000,IF( D13*12<=45000,(D 13*12)*10%,IF(دي13*12< =60000,(D13*12-45000)*15%+45000*10%, IF(D13* 12<=200000)*12-600000)*20%,IF*D13*12=400000)*12<=400000*12-200)*22.5%+140000*20% IF (D13 *12<=200000*12-200000*20%+600*20%+IF(D13=400000,(D113*12-200000) 22.5%+140000*20%+6000*15%، IF(D13*12. >400000,(d13*12-400000)*25%+200000*22.5% +140000*20%+60000*15.0))))،IF(D11*12)<=1200000,IF(D13 *12)*12 )*25%,IF( D13*12>=1200000،(D13*12.12-1200000)*27.5%+1200000*25%,0))))))/12,0)
-----------
شيت اكسل جاهز
https://drive.google.com/.../11Xeo4Ki8Joa3a_P5dj5.../view... (https://drive.google.com/file/d/11Xeo4Ki8Joa3a_P5dj5_68ghnsZRSC1Z/view?usp=sharing&fbclid=IwAR1W044I5l3BEuWBB7Mu7SYHwHlNBAN7jrmsGdgfP x0CDZiwaf7NYMUs7uA)
-----------