If else condition help needed
-
Hi, i have a number field in which user will enter any value. Now, I want to use if else condition based on that value. how I will use it?
-
Hi, I made modifications in code but now it isn’t working. The calculator doesn’t stuck but the code doesn’t work.
(function(){ var options = ['Ger?te > Computer, Tablets & Netzwerk','Ger?te > Drucker','Ger?te > PC- und Videospiele > Ersatzteile & Werkzeuge','Ger?te > Foto & Camcorder','Ger?te > Foto- und Camcorder > Speicherkarten','Ger?te > Foto- und Camcorder > Objektive','Ger?te > Mobiltelefone & Kommunikation','Ger?te > Mobiltelefone & Kommunikation > Speicherkarten','Ger?te > Haushaltsger?te','Ger?te > PC- und Videospiele > Konsolen','Ger?te > Scanner','Ger?te > PC- und Videospiele > Speicherkarten','Ger?te > TV, Video & Audio','Ger?te > Elektrische Ger?te für Enthaarung und Rasur','Ger?te > Elektrische Mund- und Zahnpflege','Ger?te > Elektrische Haarstylingger?te','Zubeh?r > Drucker, Scanner & Zubeh?r','Zubeh?r > Ersatzteile & Werkzeuge > TV, Video & Audio','Zubeh?r > Zubeh?r für Mobiltelefone','Zubeh?r > Batterien & Strom für den Haushalt','Zubeh?r > Kabel & Stecker','Zubeh?r > Kameras, Drohnen & Fotozubeh?r','Zubeh?r > Notebook- & Desktop-Zubeh?r','Zubeh?r > Objektive & Filter','Zubeh?r > Stative & Zubeh?r','Zubeh?r > Tablet- & eBook-Zubeh?r','Zubeh?r > Tastaturen, M?use & Zeigeger?te','Zubeh?r > TV- & Home-Audio-Zubeh?r','Zubeh?r > PC- und Videospiele > Zubeh?r','Zubeh?r > Zubeh?r für tragbare Audioger?te','Auto & Motorrad > Teile','Auto & Motorrad > Autoentertainment','Auto & Motorrad > Dashcams','Auto & Motorrad > Elektronik-Zubeh?r','Auto & Motorrad > Einparkhilfen','Auto & Motorrad > GPS & Navigationsger?te','Auto & Motorrad > Zubeh?r für Ladestationen & Ladeger?te','Auto & Motorrad > Ladestationen & -ger?te','Auto & Motorrad > Felgen','Auto & Motorrad > Komplettr?der','Auto & Motorrad > Reifen','Auto & Motorrad > Bekleidung, Schutzausrüstung & Handelswaren','Auto & Motorrad > Transportsysteme','Auto & Motorrad > Motor?l','Gewerbe & Industrie','Garten & Terrasse','HEIMWERKEN','Kleidung & Accessoires','Sneaker ( Unterkategorie von Herrenschuhen )','Sneaker ( Unterkategorie von Damenschuhen )','Uhren & Schmuck','Uhren & Schmuck > Armbanduhren & Taschenuhren','Uhren & Schmuck > Armbanduhren & Taschenuhren > Sammleruhren','Uhren & Schmuck > Weitere Uhren','Uhren & Schmuck > Zubeh?r','Medien > Filme und Serien (au?er Film NFTs #262053)','Medien > Musik (au?er Musik NFTs #262054)','Medien > Eintrittskarten','Medien > PC- und Videospiele','Musikinstrumente','NFTs > Film-NFTs','NFTs > Musik NFTs','NFTs > NFT-Kunst','NFTs > TCG NFTs','NFTs > Nicht-Sport Sammelkarten NFTs','NFTs > Sport-Trading-Card-NFTs','NFTs > Aufstrebende NFTs','Antiquit?ten & Kunst ( Au?er NFT Kunst # 262051 )','Baby','Handwerk & Künstlerbedarf','Sch?nheit & Gesundheit ( Ausnahmen sind: Elektrische Ger?te für Enthaarung und Rasur # 260783 Elektrische Mund- und Zahnpflegeger?te # 260774 Elektrische Haarstylingger?te # 260773 )','Briefmarken','Bücher und Zeitschriften','Büro- und Schreibwaren','Feinschmecker','Haustierbedarf','M?bel & Wohnen','Modellbau','Münzen','Reisen','Sammeln & Seltenes ( Ausnahmen sind: Aufstrebende NFTs # 262050 TCG NFTs # 262056 Nicht-Sport Sammelkarten NFTs # 262052 Sport Trading Card NFTs # 262055 )','Spielzeug','Sport','Verschiedene']; var del = ['Eurozone und Schweden','Europa','USA & KANADA','UK','Alle anderen L?nder']; var perd = [0,0.016,0.016,0.012,0.033]; var adops = ['Keine','Bis zu 24 Fotos hinzufügen','Galerie Plus','Preisvorschlag (bei Angeboten im Festpreisformat)','Sofort-Kaufen-Preis (bei Auktionsangeboten)','Mindestpreis (bei Auktionsangeboten)','Untertitel','Startzeitplanung','Angebot mit nicht ?ffentlicher Bieter-/K?uferliste']; var adval = [0,0,2.75,0,0,MIN(fieldname33*0.03,150),1.5,0,0.35]; for (var i = 0; i < 16; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 0; i < 16; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1, fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05, fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05, fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05, fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35, fieldname31*0.065,0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 16; i < 30; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 31; i < 38; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 38; i < 41; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.065),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 41; i < 44; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 45; i < 47; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 48; i < 50; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.12),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 51; i < 55; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 55; i < 59; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.09),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.05,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.05,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.05,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.05,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.05,0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 60; i < 67; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.05),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 0; j < 16; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,fieldname31*0.02,0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,fieldname31*0.02,0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 16; j < 30; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 31; j < 38; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 38; j < 41; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.065, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 41; j < 44; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 45; j < 47; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 48; j < 50; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.12, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 51; j < 55; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 55; j < 59; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.09, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 60; j < 67; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.05, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.05),0,perd[m],adval(k)); } } } } } } } for (var i = 67; i < 84; i++) { for (var j = 67; j < 84; j++) { for (var k = 0; k < 9; k++) { for (var m = 0; m < 5; m++) { if (AND(fieldname16 == 'Normales Angebot (Jetzt kaufen)', fieldname45 == options[i], fieldname46 == options[j], fieldname48 == adops[k], fieldname17 == 'Zweite Kategorie', fieldname26 == del[m])) { if (AND(fieldname39 == 'Ja', fieldname40 == 'Basis-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.1,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Top-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Premium-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (AND(fieldname39 == 'Ja', fieldname40 == 'Platin-Shop')){ if (fieldname31 < 300) { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*fieldname30*0.05,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } else if (fieldname39 == 'Nein') { if (fieldname31<990) { return SUM(2*0.35,MAX(fieldname31*0.11, fieldname31*0.11),0,perd[m],adval(k)); } else { return SUM(2*0.35,MAX(fieldname31*0.02, fieldname31*0.02),0,perd[m],adval(k)); } } } } } } } })();Hello @asjad492
I’m sorry, but I’m not implementing your code. If your equation does not return an result, you should check manually the values you are entering and if your conditions satisfy the values entered or not.
If you need we implement your project, you can contact us directly through the plugin website. We cannot debug equations with 6553 lines of code through the support service.
Best regards.
- The topic ‘If else condition help needed’ is closed to new replies.
