Conditional Rule question

[1953emp]

I have a cell with a data validation list containing 3 items, "Internal", "External", "TBD". Based on what is selected in that list I want an integer to be placed in the next cell. IE: User selects "Internal" a rule puts a 1 in the next cell to the right. I can do a conditional format where I set a cell color based on a cell value but I can't get through this one. Any help is appreciated.
Thanks

 

[etaf]

In the next cell to the right put
=IF( cell with data validation = "internal", 1 ,"" )

 

[1953emp]

In the next cell to the right put
=IF( cell with data validation = "internal", 1 ,"" )

Is the the rule in conditional formatting or a formula put into the cell?

 

[etaf]

formula put into the cell

 

[1953emp]

formula put into the cell

Ok that works, how do I expand it with an else for the other selections in the list?

 

[etaf]

what do you want to put in the cell for the other selections

=IF( cell with data validation = "internal", 1 ,IF( cell with data validation = "External", 2 , IF( cell with data validation = "TBD", 3 ,"" ) ) )

 

[1953emp]

what do you want to put in the cell for the other selections

=IF( cell with data validation = "internal", 1 ,IF( cell with data validation = "External", 2 , IF( cell with data validation = "TBD", 3 ,"" ) ) )

Thanks a ton, that functions perfectly.

 

[etaf]

you are welcome

 

[etaf]

just an added note
if you are using a later version of excel - then IFS() maybe possible, just for completeness and if someone else searching the forum who has 365 version and 2019 versions
=IFS( cell with data validation = "internal", 1 ,cell with data validation = "External", 2 , cell with data validation = "TBD", 3 , TRUE , "")

again with excel 2019 and 365 versions
=SWITCH(cell with data validation,"internal",1,"External",2,"TBD",3,"")