Nested if else when first if is true

Question

I am new to Alteryx and trying to use nested if-else statement. I tried searching but didn't get a case similar to mine. let us say passing marks for in two main subjects are 30 each and to pass overall student should be present in the class 90% of the time. What I need is

if (Marks1 > 30 and Marks2> 30 Then ( If (Attendance > 90), then "PASS" else "FAIL due to less attendance"), else "FAIL due to fewer marks") so I want that if first statements are true then I can have another if statement.

grazitti_sapna · Accepted Answer

Hi @aashishbhardwaj , I mocked up a workflow I hope it helps.

Thanks.