SOLVED

isnumber

Contributor

=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 . 

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?
best response confirmed by Xeryar (Contributor)
Solution
This two parts:
IF(ISNUMBER(SEARCH("Agree",B14)),4
IF(ISNUMBER(SEARCH("Strongly Agree",B14)),5