verwendete Formeln |
Zelle | Formel | Bereich |
AF5 | =WENN(AC5="";"";WENN(AC5>=1800;AD5*3;AD5*2)) | |
AG5 | =WENN(AB5>=1050;AB5-95;"") | |
AH5 | =WENN(AE5="";"";WENN(UND(AE5=40;AG5>0);130;150)) | |
AI5 | =WENN(AE5=40;"24/24/50/24/24";WENN(AE5=50;"24/34/50/34/24";"")) | |
AK5 | =SUMMENPRODUKT(($AG$5:$AG$20=AM5)*($AH$5:$AH$20=130)*($AD$5:$AD$20)) | |
AL5 | =SUMMENPRODUKT(($AG$5:$AG$20=AM5)*($AH$5:$AH$20=150)*($AD$5:$AD$20)) | |
AM5 | =MIN(AG5:AG20) | |
AF6 | =WENN(AC6="";"";WENN(AC6>=1800;AD6*3;AD6*2)) | |
AG6 | =WENN(AB6>=1050;AB6-95;"") | |
AH6 | =WENN(AE6="";"";WENN(UND(AE6=40;AG6>0);130;150)) | |
AI6 | =WENN(AE6=40;"24/24/50/24/24";WENN(AE6=50;"24/34/50/34/24";"")) | |
AK6 | =SUMMENPRODUKT(($AG$5:$AG$20=AM6)*($AH$5:$AH$20=130)*($AD$5:$AD$20)) | |
AL6 | =SUMMENPRODUKT(($AG$5:$AG$20=AM6)*($AH$5:$AH$20=150)*($AD$5:$AD$20)) | |
AM6 | =WENN(MAX($AG$5:$AG$20)=MAX(AM$5:AM$5);"";KGRÖSSTE($AG$5:$AG$20;ZÄHLENWENN($AG$5:$AG$20;">"&AM5))) | |
AF7 | =WENN(AC7="";"";WENN(AC7>=1800;AD7*3;AD7*2)) | |
AG7 | =WENN(AB7>=1050;AB7-95;"") | |
AH7 | =WENN(AE7="";"";WENN(UND(AE7=40;AG7>0);130;150)) | |
AI7 | =WENN(AE7=40;"24/24/50/24/24";WENN(AE7=50;"24/34/50/34/24";"")) | |
AK7 | =SUMMENPRODUKT(($AG$5:$AG$20=AM7)*($AH$5:$AH$20=130)*($AD$5:$AD$20)) | |
AL7 | =SUMMENPRODUKT(($AG$5:$AG$20=AM7)*($AH$5:$AH$20=150)*($AD$5:$AD$20)) | |
AM7 | =WENN(MAX($AG$5:$AG$20)=MAX(AM$5:AM$5);"";KGRÖSSTE($AG$5:$AG$20;ZÄHLENWENN($AG$5:$AG$20;">"&AM6))) | |
AF8 | =WENN(AC8="";"";WENN(AC8>=1800;AD8*3;AD8*2)) | |
AG8 | =WENN(AB8>=1050;AB8-95;"") | |
AH8 | =WENN(AE8="";"";WENN(UND(AE8=40;AG8>0);130;150)) | |
AI8 | =WENN(AE8=40;"24/24/50/24/24";WENN(AE8=50;"24/34/50/34/24";"")) | |
AK8 | =SUMMENPRODUKT(($AG$5:$AG$20=AM8)*($AH$5:$AH$20=130)*($AD$5:$AD$20)) | |
AL8 | =SUMMENPRODUKT(($AG$5:$AG$20=AM8)*($AH$5:$AH$20=150)*($AD$5:$AD$20)) | |
AM8 | =WENN(MAX($AG$5:$AG$20)=MAX(AM$5:AM$5);"";KGRÖSSTE($AG$5:$AG$20;ZÄHLENWENN($AG$5:$AG$20;">"&AM7))) | |
AF9 | =WENN(AC9="";"";WENN(AC9>=1800;AD9*3;AD9*2)) | |
AG9 | =WENN(AB9>=1050;AB9-95;"") | |
AH9 | =WENN(AE9="";"";WENN(UND(AE9=40;AG9>0);130;150)) | |
AI9 | =WENN(AE9=40;"24/24/50/24/24";WENN(AE9=50;"24/34/50/34/24";"")) | |
AK9 | =SUMMENPRODUKT(($AG$5:$AG$20=AM9)*($AH$5:$AH$20=130)*($AD$5:$AD$20)) | |
AL9 | =SUMMENPRODUKT(($AG$5:$AG$20=AM9)*($AH$5:$AH$20=150)*($AD$5:$AD$20)) | |
AM9 | =WENN(MAX($AG$5:$AG$20)=MAX(AM$5:AM$5);"";KGRÖSSTE($AG$5:$AG$20;ZÄHLENWENN($AG$5:$AG$20;">"&AM8))) | |
AF10 | =WENN(AC10="";"";WENN(AC10>=1800;AD10*3;AD10*2)) | |
AG10 | =WENN(AB10>=1050;AB10-95;"") | |
AH10 | =WENN(AE10="";"";WENN(UND(AE10=40;AG10>0);130;150)) | |
AI10 | =WENN(AE10=40;"24/24/50/24/24";WENN(AE10=50;"24/34/50/34/24";"")) | |
AK10 | =SUMMENPRODUKT(($AG$5:$AG$20=AM10)*($AH$5:$AH$20=130)*($AD$5:$AD$20)) | |
AL10 | =SUMMENPRODUKT(($AG$5:$AG$20=AM10)*($AH$5:$AH$20=150)*($AD$5:$AD$20)) | |
AM10 | =WENN(MAX($AG$5:$AG$20)=MAX(AM$5:AM$5);"";KGRÖSSTE($AG$5:$AG$20;ZÄHLENWENN($AG$5:$AG$20;">"&AM9))) | |
AF11 | =WENN(AC11="";"";WENN(AC11>=1800;AD11*3;AD11*2)) | |
AG11 | =WENN(AB11>=1050;AB11-95;"") | |
AH11 | =WENN(AE11="";"";WENN(UND(AE11=40;AG11>0);130;150)) | |
AI11 | =WENN(AE11=40;"24/24/50/24/24";WENN(AE11=50;"24/34/50/34/24";"")) | |
AK11 | =SUMMENPRODUKT(($AG$5:$AG$20=AM11)*($AH$5:$AH$20=130)*($AD$5:$AD$20)) | |
AL11 | =SUMMENPRODUKT(($AG$5:$AG$20=AM11)*($AH$5:$AH$20=150)*($AD$5:$AD$20)) | |
AM11 | =WENN(MAX($AG$5:$AG$20)=MAX(AM$5:AM$5);"";KGRÖSSTE($AG$5:$AG$20;ZÄHLENWENN($AG$5:$AG$20;">"&AM10))) | |