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!!!!

If cell is a,b or c then 1,2 or 3
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
Excel if cell contains date then return value ✓ - Forum - Office Software
It restricts what values are possible for cells that contain numbers, dates, and text ✓ - Forum - Excel
Macro copy and paste in next blank cell - Guide
Google sheets if cell contains any text then ✓ - Forum - Excel

1 reply

Answer 1 / 1

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

769
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,"")))

mltplyn
Jun 10, 2010 at 12:15 PM

Thank you for the fast reply!!! ;)

Subscribe To Our Newsletter!