Excel If function

JEANETTE GONZALEZ 1 Reputation point
2021-06-25T19:26:20.257+00:00

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
    2021-06-28T09:18:03.517+00:00

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

    https://support.microsoft.com/en-us/office/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45

    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
    2021-06-25T21:01:34.597+00:00

    Hi @JEANETTE GONZALEZ ,

    maybe this is helpful:
    https://excelexplained.com/if-function-with-3-conditions

    ----------

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

    Regards
    Andreas Baumgarten

    0 comments No comments