If cell is a,b or c then 1,2 or 3
Solved/Closed
Related:
- 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
rizvisa1
Jun 10, 2010 at 12:09 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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