SOLVED

New Contributor

# 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,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

Best regards

Egor

2 Replies
best response confirmed by EgorFast (New Contributor)
Solution

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

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