Adding to formula

[mikesal57]

Hello all...

I'm sure this is not to difficult for the experts here....

To this formula =IF(AND(P2<=2,M2=0,C2="ct"),"PLAY","")

I would like to add more to this c2 cell.....

Example "DED"....."GP"......"LRC".....and others

thxs

 

[hrayani]

See if below helps

=IF(AND(P2<=2, M2=0, OR(C2="ct", C2="DED", C2="GP", C2="LRC")), "PLAY", "")

 

[mikesal57]

Hit it!!!

thxs

 

[hrayani]

Hit it!!!

thxs

you are welcome & thanks for the feedback