Excel If function

Question

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

Answer 1

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.

Answer 2

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