locked
IF OR Syntax in SharePoint RRS feed

  • Question

  • I need help adding some logic to my syntax...current formula is set to the following value and it works perfectly:

    =IF(AAA<>"","Closed",IF([BBB]<>"","Pending Approval","Pending Review"))

    I'd like to add some OR logic to this part ([BBB]<>""OR"ZZZ", and essentially want the formula to perform this:

    =IF(AAA<>"","Closed",IF([BBB]<>""OR"ZZZ","Pending Approval","Pending Review"))

    this doesn't work either:

    =IF(AAA<>"","Closed",IF(OR(ISBLANK([BBB]),"Pending Approval"),"Pending Review"),(OR([BBB])<>"ZZZ","Pending Approval","Pending Review")

    Can anyone help with this?

    Thursday, February 28, 2019 9:56 PM

All replies

  • Hi

    Please try below, remember totally replace.

    Change 

    IF([BBB]<>"","Pending Approval","Pending Review")

    to

    IF(OR([BBB]<>"",[BBB]<>"ZZZ"),"Pending Approval","Pending Review")


    Justin Liu Office Apps & Services MVP, MCSE
    Senior Software Engineer
    Please Vote and Mark as Answer if it helps you.

    Friday, March 1, 2019 5:30 AM