If formula question

Closed

Jim - 29 Mar 2016 à 10:06
RayH - 29 Mar 2016 à 16:47

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 responses

Réponse 1 / 2

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
29 Mar 2016 à 12:04

Hi Jim,

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

Best regards,
Trowa

Réponse 2 / 2

RayH
29 Mar 2016 à 16:47

Also, try these alternatives:

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

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