If formula to replace entries?

[milwphil]

Good morning!

First I have to thank everyone that has helped me on this message board. I've received amazing insight and appreciate those willing to share their knowledge.

Forgive me for the question, it seems as if it should be fairly simple but I'm getting lost. Formulas are not my strong point!

Basically, I'm trying to write a formula that 'if' the user enters "AD" or "NA" in A1 to return a value "AS" in B1, 'if' the user enters "IA" or "N" in A1 to return a value "NS" in B1, if blank-nothing.

Any help would be greatly appreciated!!

Thanks,
Phil

 

[VoG]

Try

=IF(OR(A1="AD",A1="NA"),"AS",IF(OR(A1="IA",A1="N"),"NS",""))