Need help with IFS function for a field that is NOT BLANK

[lemery]

Here is the formula I'm using: =IFS((A2="cleanse"),"Contact Append",(A2="enrich"),"Contact Append",(AND(A2="*",OR(AM2="highrisk",G2="mediumrisk"))),"Company Append",(AND(AM2="",OR(A2="highrisk",G2="mediumrisk"))),"Unknown")

The section I'm having trouble with is: (AND(A2="*",OR(AM2="highrisk",G2="mediumrisk"))),"Company Append"
When I have a scenario fitting the situation, the Answer comes back as N/A rather than Company Append.

I know A2="*" is the way to say 'if A2 is not blank'. From my research it looks like you can't do NOT BLANK for IFS statements. I saw: (AND(A2<>="*",OR(AM2="highrisk",G2="mediumrisk"))),"Company Append"
as an option, but I tried it and it came back with an error correcting it to (AND(A2<="*",OR(AM2="highrisk",G2="mediumrisk"))),"Company Append"
which didn't work.

 

[lemery]

I found an error in my logic and fixed it.