Hi, I'm trying to write the correct syntax for the following yes/no statements so that the parameter Bars will provide the correct Yes/No result.
If Show Glazing Bars and Single Bank or Double Bank or Triple Bank are true , the parameter Bars" will also be true.
Gelöst! Gehe zur Lösung
Gelöst von Alfredo_Medina. Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
or(and(Show Glazing Bars, Single Bank), and(Show Glazing Bars, Double Bank), and(Show Glazing Bars, Triple Bank))
Hi @ToanDN thanks for the quick reply.
I tried using the or option using "or(Show Glazing Bars, Single Bank, Double Bank, Triple Bank)" but it doesn't provide the correct result.
I think it needs to be something like and(Show Glazing Bars or(Single Bank, Double Bank, or Triple Bank) but my knowledge of the correct syntax is wrong.
Does this make sense of what I am trying to do?
I have a comment. This formula could be simplified like this:
and(Show Glazing Bars, or(Single Bank, Double Bank, Triple Bank))
Only one AND and one OR.
OR and AND statements can have multiple parameters separated by commas. It's not necessary to do multiple OR or AND statements, each with two parameters.
Thanks @Alfredo_Medina
Yes that is a more simple, elegant way of writing the formula, I do like it.
ToanDH did write his solution and got it back within minutes of my request for help so I am really impressed with both solutions.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.