Forum Discussion
lauzwauz
Apr 22, 2020Copper Contributor
Error while using IF-Funktion
Hello everbody, I am using Excel in German so I hope all the translations are clear. ("=WENN" = "=IF") i think.... I wrote: =WENN(90,01<D10<100; 1; =WENN(80,01<D10<90; 2; =WENN(70,01<D10<...
Riny_van_Eekelen
Apr 22, 2020Platinum Contributor
Delete all the =-signs, except for the first.
=WENN(90.01<100; 1; WENN(80,01<90; 2; WENN(70,01<80;3; WENN(60,01<70;4; WENN(50<40;4;5)))))