Forum Discussion
Solved
isnumber
=IF(ISNUMBER(SEARCH("Strongly Disagree",B14)),1,IF(ISNUMBER(SEARCH("Disagree",B14)),2,IF(ISNUMBER(SEARCH("Neutral",B14)),3,IF(ISNUMBER(SEARCH("Agree",B14)),4,IF(ISNUMBER(SEARCH("Strongly Agree",B14)),5,IF(ISNUMBER(SEARCH("TBD",B14)),""))))))
The strongly agree is also giving me 4 . Can someone advise .
- This two parts:
IF(ISNUMBER(SEARCH("Agree",B14)),4
IF(ISNUMBER(SEARCH("Strongly Agree",B14)),5
3 Replies
- IF() stops when it finds "Agree" - also as part of "Strongly agree".
Just swap this two parts in the formula.- i am sorry i am new in excel it went over my head lol . What am I swapping?
- This two parts:
IF(ISNUMBER(SEARCH("Agree",B14)),4
IF(ISNUMBER(SEARCH("Strongly Agree",B14)),5
