Forum Discussion
Solved
WENNS(German Version)/ IFS(english version) combining UND/AND function
Hi, i´m wondering if that possible to combine IFS Formula with an AND Formula. I´ve tried it in different ways but somehow it doesn´t work. I´ve got a lot of IFS so example: IFS(A1="Munich";C1*0,...
=IFS(UND(A1="Stuttgart",B1="white"),C1*0.09,AND(A1="Leipzig",B1="red"),C1*0.09,A1="Frankfurt",C1*0.07)In the english Excel version you have to replace " ; " by " , " as far as i know. And C1*0,09 is C1*0.09 i suppose.
In the german Excel version this one works as shown in the attached file:
=WENNS(UND(A1="Stuttgart";B1="white");C1*0,09;UND(A1="Leipzig";B1="red");C1*0,09;A1="Frankfurt";C1*0,07)
=IFS(UND(A1="Stuttgart",B1="white"),C1*0.09,AND(A1="Leipzig",B1="red"),C1*0.09,A1="Frankfurt",C1*0.07)In the english Excel version you have to replace " ; " by " , " as far as i know. And C1*0,09 is C1*0.09 i suppose.
In the german Excel version this one works as shown in the attached file:
=WENNS(UND(A1="Stuttgart";B1="white");C1*0,09;UND(A1="Leipzig";B1="red");C1*0,09;A1="Frankfurt";C1*0,07)
Thank you 🙂