Replicate IF AND OR Excel Formula Using Priority

Question

Hello

I am having some trouble replicating this excel formula in Alteryx I posted what I currently have and its giving me the wrong numbers.

It seems excel follows a priority path Alteryx doesn’t have or cannot calibrate without the use of syntax or other methods

In the images we have column AC,AD,AE used to populate column AG based on several criteria, row 5 is those staments above the headers “Not in IB output”, “Not in coalition” etc

The yellow section is what I’m doing data validation on

If I can improve my formula to get those numbers in column AG from the source columns that’s will solve my issue I just can’t find the right syntax or order.

Thanks

Carlos_Tovar · Answer

I solved the issue on my own thanks

AncientPandaman · Answer

Could you share some sample input data, and example output here?

Carlos_Tovar · Answer

I had AND before there and that also doesn’t work