Multiple IF statements sharepoint calculated column

Developer1911 20 Reputation points
2024-06-06T15:33:18.5766667+00:00

Hello I'm trying to combine 3 IF statements in my sharepoint calculated column. Here is what I have so far. I'm receiving an error message any feedback would be prefect. What I'm basically trying to do is If all the columns are no print out no, if any are yes print out yes, and if any of them are blank print of N/A

=IF([Column 1]="No",([Column 2])="No",([Column 3])="No"),"No",
IF(OR([Column 1]="Yes",([Column 2])="Yes",([Column 3])="Yes"),"Yes",
IF(OR(ISBLANK([Column 1]),ISBLANK([Column 2]),ISBLANK([Column 3]))," N/A"))
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
540 questions
{count} votes

Accepted answer
  1. Yanli Jiang - MSFT 22,961 Reputation points Microsoft Vendor
    2024-06-07T08:13:27.8+00:00

    Hi @Developer1911 ,

    There are some grammatical errors in your formula. Please try the following formula:

    =IF(AND([Column 1]="no",[Column 2]="no",[Column 3]="no"),"no",
    IF(OR([Column 1]="yes",[Column 2]="yes",[Column 3]="yes"),"yes",
    IF(OR(ISBLANK([Column 1]),ISBLANK([Column 2]),ISBLANK([Column 3])),"N/A")))
    

    This is my test result:

    User's image

    Have a nice day!


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful