=IF(A1="Red", "Yes",(IF(A1="Green","Yes",(IF(A1="Blue", "No","N/A")))))
you can also assign values to colours and use a vlookup.
I'm sure there's other ways as well. I'd be interested in how other posters would do it differently.
__________________
The Delhi police have announced the formation of a crack team dedicated to nabbing the elusive 'Monkey Man' and offered a reward for his -- or its -- capture.
Last edited by monkeyman; 08-04-2018 at 04:32 PM.
Reason: updated to better fit example.
|