Share via

Excel IF OR and AND formula continues to deliver a zero result

Anonymous
2025-05-07T20:13:33+00:00

Hi Colleagues,

I have created an Excel drop down list in Cell B19, containing the options: Excellent, Strong, Reasonable.

I am trying to write an Excel formula in Cell D19 that will return a respective "A", "B" or "C" result if any of the above three options are selected from the B19 drop down list.

The Excel formula I have written in D19 is:

=IF(OR(B19="Excellent"),"A",IF(AND(B19="Strong"),"B",IF(AND(B19="Reasonable"),"C",)))

The Excel formula works when selecting Excellent or Reasonable, however when I select Strong a "0" is populated in D19.

I'm seeking the Community's help with my formula, and I'm open to all suggestions for other formulas they mau work.

Microsoft 365 and Office | Excel | For business | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-05-07T20:21:56+00:00

    Hi Scott

    Please

    Try the formula

    =IF(B19="Excellent","A",IF(B19="Strong","B",IF(B19="Reasonable","C","")))

    I hope this helps you and gives a solution to your problem.

    Regards

    Jeovany

    0 comments
  2. HansV 460.7K Reputation points MVP Volunteer Moderator
    2025-05-07T20:22:20+00:00

    You don't need AND/OR here - you can simplify the formula to

    =IF(B19="Excellent","A",IF(B19="Strong","B",IF(B19="Reasonable","C","")))

    Check carefully that the source of the drop-down list really has "Strong" and not - for example - "Strong " (with an extra space).

    0 comments
  3. Anonymous
    2025-05-07T20:31:13+00:00

    Thanks for your prompt reply. "Excellent" and "Reasonable" results are working, however "Strong" now returns a blank field where (in theory) it should return a "B".

    0 comments
  4. HansV 460.7K Reputation points MVP Volunteer Moderator
    2025-05-07T20:53:56+00:00

    The only explanation I can think of is that B19 contains something like "Strong " instead of "Strong".

    If you cannot find the cause:

    Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

    0 comments
  5. Ashish Mathur 99,580 Reputation points Volunteer Moderator
    2025-05-07T23:26:27+00:00

    Hi,

    In cell D19, enter this formula

    =SWITCH(TRUE,B19="Excellent","A",B19="Strong","B","C")

    Hope this helps.

    0 comments