Formula Help!

[Disarmonious]

I'll try to simplify this question; I would like a cell to display a return value/answer "Yes" or "No". I would like to know if there's a simpler way to formulate this cell;

=IF(E8="","",IF(E8="Chat (CC)","Yes",IF(E8="Chat (OCS)","Yes",IF(E8="Chat (RSCC)","Yes",IF(E8="Credit Card Email","Yes",IF(E8="Email BOB (OCS)","Yes",IF(E8="Email (NBBC)","Yes",IF(E8="Email (OCS)","Yes","No"))))))))

Example:

if cell E8 = Chat (CC) or Chat (OCS) or Chat (RSCC), etc. it will return a "Yes" response, otherwise, it returns a "No" response

 

[Fluff]

You can do it like
=IF(E8="","",IF(OR(E8={"Chat (CC)","Chat (OCS)","Chat (RSCC)"}),"Yes","NO"))

 

[Disarmonious]

Fluff,

Thanks!

 

[Fluff]

You're welcome