If cell is a,b or c then 1,2 or 3

[Solved/Closed]
Report
-
 mltplyn -
Hello,

I am trying to get a formula that will let my put a numerical value in one cell dependant on the word in another cell for example a1="word1" then "1", if a1="word2" then "2" if a1="word3" then "3"



Thanks for all of the help!!!!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can have upto 7 nested IF

having said that

=IF(A1="word1", 1, IF(A1="word2", 2, IF(A1=""word3", 3,"")))
Thank you for the fast reply!!! ;)