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

Answer 1 / 2

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

Answer 2 / 2

RayH
Mar 29, 2016 at 04:47 PM

Also, try these alternatives:

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

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