IF Expression Issue

[amandaj4123]

Hi!  I have attempted the below formula several times, rearranged, used " " instead of IsNull, but my results are still incorrect.  I could use some input on how to resolve.  

IF [A]="Non-Test" && [C]!="" THEN "" ELSEIF [A]="TEST" && IsNull([C]) THEN "" ELSEIF [A]="TEST1" && IsNull([C]) THEN "" ELSEIF [A]="TEST2" && IsNull([C]) THEN "" ELSEIF [A]="TEST3" && IsNull([C]) THEN "" ELSE "Validation Required" ENDIF 

I am trying to achieve the following...

1) IF [A] = Non-Test AND [C] is blank THEN "Validation Required"

2) IF [A] = TEST, TEST1, TEST2, TEST3 is NOT blank THEN "Validation Required"

Thanks,

Mandy

[MarqueeCrew]

@amandaj4123,

I am glad to help you :).

Have an awesome weekend :)

Mark

[amandaj4123]

Thank you...you, too!

So happy to be part of the Alteryx Community and grateful that you're in it!  

Salute,

Mandy