Sharepoint calculated column

Developer1911 20 Reputation points

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")))
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,992 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 17,421 Reputation points Microsoft Vendor

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

    User's image

    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.

    0 comments No comments