Forum Discussion

Drclone's avatar
Drclone
Copper Contributor
Mar 21, 2022
Solved

Result of formula isn't a numer

Hi peeps!   I need some help with my formula in excel.   Here my example: f5 5 no ONWAAR The f5 is in row A, 5 row B etc.   So whats going on? Row A In the first cel you see "f5"...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 21, 2022

    Drclone 

    You compare text with number, it always "no". It could be

    =IF(B1="5";"yes";"no")

    or add double dash in front of substitutes formula.

HansVogelaar's avatar
HansVogelaar
MVP
Mar 21, 2022

Drclone 

Change the formula to

 

=--SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(KLEINE.LETTERS(A1);"a";);"b";);"c";);"d";);"e";);"f";);"g";);"h";);"i";);"j";);"k";);"l";);"m";);"n";);"o";);"p";);"q";);"r";);"s";);"t";);"u";);"v";);"w";);"x";);"y";);"z";);"A";);"B";);"C";);"F";);"S";);"W";);" ";)

 

Note that I moved KLEINE.LETTERS to immediately before A1.

  • Drclone's avatar
    Drclone
    Copper Contributor
    Mar 21, 2022
    Wow both of the options work! Yours and the one of sergei. Consider this one absolutely solved

Resources