Forum Discussion

Xeryar's avatar
Xeryar
Brass Contributor
Dec 23, 2021
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))...
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Dec 23, 2021
    This two parts:
    IF(ISNUMBER(SEARCH("Agree",B14)),4
    IF(ISNUMBER(SEARCH("Strongly Agree",B14)),5
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Dec 23, 2021
IF() stops when it finds "Agree" - also as part of "Strongly agree".
Just swap this two parts in the formula.
Xeryar's avatar
Xeryar
Brass Contributor
Dec 23, 2021
i am sorry i am new in excel it went over my head lol . What am I swapping?
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Dec 23, 2021
    This two parts:
    IF(ISNUMBER(SEARCH("Agree",B14)),4
    IF(ISNUMBER(SEARCH("Strongly Agree",B14)),5

Resources