Replicate IF AND OR Excel Formula Using Priority

[Carlos_Tovar]

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 

[PangHC]

ELSEIF ([TAM TMO Wallet Estimate] != "Not included in Exercise") and ([TAM TMO Wallet Estimate] != "No estimate") THEN
[TAM TMO Wallet Estimate]
ELSEIF ([Coalition Wallet Estimate] != "Not in Coalition Study") and ([Coalition Wallet Estimate] != "0") then

[Carlos_Tovar]

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

[PangHC]

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

[Carlos_Tovar]

I solved the issue on my own thanks