SOLVED

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

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3174606%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EWENNS(German%20Version)%2F%20IFS(english%20version)%20combining%20UND%2FAND%20function%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3174606%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ei%C2%B4m%20wondering%20if%20that%20possible%20to%20combine%20IFS%20Formula%20with%20an%20AND%20Formula.%20I%C2%B4ve%20tried%20it%20in%20different%20ways%20but%20somehow%20it%20doesn%C2%B4t%20work.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%C2%B4ve%20got%20a%20lot%20of%20IFS%20so%20example%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIFS(A1%3D%22Munich%22%3BC1*0%2C07%3B%20A1%3D%22Frankfurt%22%3BC1*1%2C19........%3B%20AND(A1%3D%22Leipzig%22%3BB1%3D%22Red%22)%3BC1*1%2C19)%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThat%C2%B4s%20my%20first%20post%20here%20so%20i%20hope%20that%C2%B4s%20understandable%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20Help%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EBest%20regards%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EEgor%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3174606%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

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 Replies
best response confirmed by EgorFast (New Contributor)
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)