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.
