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
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
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
Hi @JEANETTEGONZALEZ-8273,
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.
Hi @JEANETTEGONZALEZ-8273,
I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.
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.
5 people are following this question.