It has been years since I've used Excel extensively and find myself struggling with a large dataset.
Desired formula:
If Column B = 0, Column C = "No"
If Column B>0 AND Column A = "Green", Column C = "Yes"
If Column B>0 AND Column A DOES NOT = "Green", Column C = Other Color
The Yes/No logic is simple but the third result is getting the better of me. Any help would be appreciated.
Attachment 785016
Bookmarks