Previous Topic Next Topic

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

Solved/Closed
mltplyn - Jun 10, 2010 at 12:07 PM
 mltplyn - Jun 10, 2010 at 12:15 PM
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!!!!
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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,"")))
0
mltplyn
Jun 10, 2010 at 12:15 PM
Thank you for the fast reply!!! ;)
0

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses