Akif59
Altın Üye
- Katılım
- 15 Mart 2020
- Mesajlar
- 66
- Excel Vers. ve Dili
- 2013 ve 2016
- Altın Üyelik Bitiş Tarihi
- 20-03-2025
Merhaba birbirine bağlı 5 formülü tek bir makro ile yapmak mümkün müdür
=EĞERHATA(TAMSAYI(D123I123/$DJ$127);"")
=EĞERHATA(EĞER(TAMSAYI((D123I123-(D127*$DJ$127))/$DJ$128)<1;0;TAMSAYI((D123I123-(D127*$DJ$127))/$DJ$128));"")
=EĞERHATA(EĞER(EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128)>$B$125;(EĞER(TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129;0))<0;0;EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128)>$B$125;(EĞER(TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129;0)));"")
=EĞERHATA(EĞER(EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129)>$B$125;(EĞER(TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130;0))<0;0;EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129)>$B$125;(EĞER(TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130;0)));"")
=EĞERHATA(EĞER(EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130)>$B$125;(EĞER(TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131;0))<0;0;EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130)>$B$125;(EĞER(TAMSAYI((D123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131;0)));"")
=EĞERHATA(TAMSAYI(D123I123/$DJ$127);"")
=EĞERHATA(EĞER(TAMSAYI((D123I123-(D127*$DJ$127))/$DJ$128)<1;0;TAMSAYI((D123I123-(D127*$DJ$127))/$DJ$128));"")
=EĞERHATA(EĞER(EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128)>$B$125;(EĞER(TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129;0))<0;0;EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128)>$B$125;(EĞER(TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128))/$DJ$129;0)));"")
=EĞERHATA(EĞER(EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129)>$B$125;(EĞER(TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130;0))<0;0;EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129)>$B$125;(EĞER(TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129))/$DJ$130;0)));"")
=EĞERHATA(EĞER(EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130)>$B$125;(EĞER(TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131;0))<0;0;EĞER(D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130)>$B$125;(EĞER(TAMSAYI((D123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131)<1;0;TAMSAYI((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131)));YUKARIYUVARLA((D123I123-(D127*$DJ$127+D128*$DJ$128+D129*$DJ$129+D130*$DJ$130))/$DJ$131;0)));"")