Multiple IF statements sharepoint calculated column

Question

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"))

Answer 1

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:

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.