Forum Discussion
Solved
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 € ...
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%.
Hello Zytox,
Apologies - my German is not that good so I will respond in English.
The reason your formula does not work as you expect it in the 1st instance is because it works from Left to Right.
The formula checks the first condition ...C4>=300,000... and as this is correct (i.e. 549,000 IS more than 300,000), it stops there. It does not even check the second condition (...C4>=500,000...) anymore.
On your second attempt, you have indeed written it in the correct order.
Hopefully this explains it!
Apologies - my German is not that good so I will respond in English.
The reason your formula does not work as you expect it in the 1st instance is because it works from Left to Right.
The formula checks the first condition ...C4>=300,000... and as this is correct (i.e. 549,000 IS more than 300,000), it stops there. It does not even check the second condition (...C4>=500,000...) anymore.
On your second attempt, you have indeed written it in the correct order.
Hopefully this explains it!