Forum Discussion

SIBI1998's avatar
SIBI1998
Icon for Helper I rankHelper I
4 years ago
Solved

AND and AND NOT Condition

Hi,             Here I have needed AND and AND NOT Condition for ;   I have 5 Stages (Stage1,Stages2,Stages3,Stages4,Stages5) and (Verified Ekyc) as one Column I have Needed Like with the Below S...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi SIBI1998 ,

     

    Please try:

    Column = 
IF (
    [Stage1] <> BLANK ()
        && [Stage2] <> BLANK ()
        && [Stage3] <> BLANK ()
        && [Stage4] <> BLANK ()
        && [Stage5] <> BLANK ()
        && [Stage1] <> "Rejected"
        && [Stage2] <> "Rejected"
        && [Stage3] <> "Rejected"
        && [Stage4] <> "Rejected"
        && [Verified Ekyc] <> BLANK (),
    1
)

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

IF(COALESCE([Stage4],"Rejected")<>"Rejected" && COALESCE([Stage3],"Rejected")<>"Rejected" && COALESCE([Stage2],"Rejected")<>"Rejected" && COALESCE([Stage1],"Rejected")<>"Rejected" && ISBLANK([Stage5]) && ISBLANK([Verified Ekyc]),1)