Formula Help

[henrygeorge]

Hi Alteryx Team,

I have a problem in framing a formula for the below input file

Age	S/N
0	S
0	S
6	S
5	N

I want to frame a formula in such a way that I get another column 'results' with yes/no as output. If the Age is 3 and above and S/N is 'S' Then the result should be Yes and if the age is 5 and above and S/N is 'N' then the result should be Yes. Rest all that don't meet the above 4 criteria's should be a No.

Output Required -

Age	S/N	Result
0	S	No
0	S	No
6	S	Yes
5	N	Yes

Please help.

This is my formula but it gives an output as 0,-1,etc idk why?

IF [NFA Age]>3
THEN "Yes"
Else "No"

AND IF [NFA Age]>=5 AND [Swap Dealer/Non Swap Dealer]="Non Swap Dealer"
Then "Yes"
Else "No"
Endif

Endif

[Jonathan-Sherman · Accepted solution]

Hi @henrygeorge,

Is this the result you're looking for?

If so then you will want to be using the following formula:

IF [Age] >= 3 AND [S/N] = 'S'
THEN 'Yes'
ELSEIF [Age] >= 5 AND [S/N] = 'N'
THEN 'Yes'
ELSE 'No'
ENDIF

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.

Regards,

Jonathan