Sharepoint calculated column

Question

My calculated column I only want yes to display if any columns are yes; however, I want N/A to display if any columns are blank. Right now, yes is calculated when fields are empty when it should be N/A because a column is empty.Any suggestion? Below is my code

=IF(AND([AP Spend]="no",Contract="no",[SharePoint Findings]="no"),"no",
IF(OR([AP Spend]="yes",Contract="yes",[SharePoint Findings]="yes"),"yes",
IF(OR(ISBLANK([AP Spend]),ISBLANK(Contract),ISBLANK([SharePoint Findings])),"N/A")))

Answer 1

Hi @Developer1911,

According to your description, you should use this formula:

=IF(AND([AP Spend]="no",Contract="no",[SharePoint Findings]="no"),"no",
IF(OR(ISBLANK([AP Spend]),ISBLANK(Contract),ISBLANK([SharePoint Findings])),"N/A","yes"))

Hope my answer helps. Thanks.

---

If the answer is helpful, please click "Accept as 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.