WENNS(German Version)/ IFS(english version) combining UND/AND function

[EgorFast]

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,07; A1="Frankfurt";C1*1,19........; AND(A1="Leipzig";B1="Red");C1*1,19)

That´s my first post here so i hope that´s understandable 

Thank you for your Help

Best regards

Egor

[#2 · Accepted solution]

@EgorFast 

=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) 

[#3]

Thank you :)