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

%3CLINGO-SUB%20id%3D%22lingo-sub-2661048%22%20slang%3D%22en-US%22%3EHow%20do%20i%20Duplicate%20the%20result%20of%20an%20IF%20command%20into%20other%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2661048%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20dropdown%20menu%20for%20the%20user%20to%20choose%20a%20code%2C%20in%20the%20next%20cell%20i%20used%26nbsp%3B%3CSPAN%3E%3DIF(G2%3D201%2C%22YES%22%2C%22%22)%2C%20and%20the%20next%20cell%20i%20used%26nbsp%3B%3DIF(G2%3D%22All%22%2C%22YES%22%2C%22%22)%20%2C%20however%20i%20would%20like%20'yes'%20to%20appear%20in%20both%20cells%20if%20'all'%20is%20chosen.%20How%20do%20I%20do%20this%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2661048%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2661125%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20i%20Duplicate%20the%20result%20of%20an%20IF%20command%20into%20other%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2661125%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131464%22%20target%3D%22_blank%22%3E%40Martin_Stolworthy_1973%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20the%20first%20formula%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(OR(G2%3D%7B201%2C%22All%22%7D)%2C%22YES%22%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies

@Martin_Stolworthy_1973 

Change the first formula to

 

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