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.

Anonymous's avatar
Anonymous
Not applicable
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.