Forum Discussion
Zytox
Feb 20, 2022Copper Contributor
WENN Funktion Reihenfolge der Argumente zeigen verschiedene Ergebnisse?
Filiale Filialleiter Umsatz Bonus Berlin Sender 280.000 € Frankfurt Heine 549.000 € Köln Graf 310.000 € Hamburg Wulf 250.000 € München Böning 405.000 € ...
- Feb 20, 2022
Zytox In the first formula, the IF >= 500000 will never be evaluated as such an amount already meets the requirement of the first IF statement. In other words, any amount greater than 300000 will always return 2%.
Riny_van_Eekelen
Feb 20, 2022Platinum Contributor
Zytox In the first formula, the IF >= 500000 will never be evaluated as such an amount already meets the requirement of the first IF statement. In other words, any amount greater than 300000 will always return 2%.
Zytox
Feb 20, 2022Copper Contributor
Klasse! Danke euch allen!