How do i Duplicate the result of an IF command into other cells?

[Martin_Stolworthy_1973]

I have a dropdown menu for the user to choose a code, in the next cell i used =IF(G2=201,"YES",""), and the next cell i used =IF(G2="All","YES","") , however i would like 'yes' to appear in both cells if 'all' is chosen. How do I do this?

[#2 · Accepted solution]

@Martin_Stolworthy_1973 

Change the first formula to

=IF(OR(G2={201,"All"}),"YES","")

[#3]

Thank you So much!!!