question

JEANETTEGONZALEZ-8273 avatar image
0 Votes"
JEANETTEGONZALEZ-8273 asked emizhang-msft commented

Excel If function

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

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AndreasBaumgarten avatar image
0 Votes"
AndreasBaumgarten answered

Hi @JEANETTEGONZALEZ-8273 ,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft avatar image
1 Vote"
emizhang-msft answered emizhang-msft commented

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.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.


0 Votes 0 ·