If formula question

Closed
Jim - Mar 29, 2016 at 10:06 AM
 RayH - Mar 29, 2016 at 04:47 PM
Hello,
i am trying to write a fomula so that if the text in one column 1 is a,b, or c, than the text in Column 2 is a,b, or c


2 replies

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Mar 29, 2016 at 12:04 PM
Hi Jim,

Try this:
=IF(A1="a","a",IF(A1="b","b",IF(A1="c","c","")))

Best regards,
Trowa
0
Also, try these alternatives:

=IF(OR(A1="a",A1="b",A1="c"),A1,"")


=IF(NOT(ISNA(MATCH(A1,{"a","b","c"},0))),A1,"")
0