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