Solved Need Cell Value Based On Drop Down Choice

September 12, 2018 at 13:56:42
Specs: Windows 7
I have a drop down box with Yes or No. I need the cell next to it to be Pass if "Yes" and "Fail" if no. Also, I would like the cell to remain blank if an answer has not been chosen.

See More: Need Cell Value Based On Drop Down Choice

Report •

September 12, 2018 at 17:27:49
✔ Best Answer
With your Drop Down Box in cell A1, enter this formula in B1


See how that works for you.


Report •

September 13, 2018 at 06:42:31
Works! Thank you so much!

Report •

September 13, 2018 at 11:30:53

If I may, I'd like to offer a posting tip:

When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "I need a formula" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

Thanks for listening!

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Report •
Related Solutions

Ask Question