Feb 16 2022 09:42 AM
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
Feb 16 2022 10:16 AM
Solution=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)
Feb 16 2022 10:27 AM
Feb 16 2022 10:16 AM
Solution=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)