Excel If function

JEANETTE GONZALEZ 1 Reputation point

I have an If formula with multiple conditions. The problem is I need it to render one of 3 result options not just 2, for example a "Yes" "No" or N/A

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,638 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Emi Zhang-MSFT 21,626 Reputation points Microsoft Vendor

    What version of Office did you use?
    If you're using over Office 2019, you can try to use IFS function:


    I suggest you try to provide a simple sample about your problem, so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    If the response is helpful, please click "Accept Answer" and upvote it.
    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.

  2. Andreas Baumgarten 95,496 Reputation points MVP


    maybe this is helpful:


    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Andreas Baumgarten

    0 comments No comments