If cell is a,b or c then 1,2 or 3
Solved/Closed
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!!!!
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!!!!
Related:
- If cell is a,b or c then 1,2 or 3
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Hitman 3 free download - Download - Action and adventure
- Granny 3 download pc - Download - Horror
- Fnia 3 - Download - Adult games
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 10, 2010 at 12:09 PM
Jun 10, 2010 at 12:09 PM
you can have upto 7 nested IF
having said that
=IF(A1="word1", 1, IF(A1="word2", 2, IF(A1=""word3", 3,"")))
having said that
=IF(A1="word1", 1, IF(A1="word2", 2, IF(A1=""word3", 3,"")))
Jun 10, 2010 at 12:15 PM