Previous Topic Next Topic

TEXT TO NUMBER

Closed
TOM - 3 Aug 2009 à 16:29
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 3 Aug 2009 à 20:38
Hello,
CELL A1 COULD BE TOM OR JIM
I WANT CELL B1 TO = 1 FOR TOM AND 2 FOR JIM

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
3 Aug 2009 à 20:38
=IF(A1="Tom",1,IF(A1="jim",2,""))

this is formula in B1