Forum Discussion

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

SergeiBaklan

Diamond Contributor

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.

Drclone
Copper Contributor
Mar 21, 2022
Wow! I've been looking for so long haha. Thank you!