Formulas not showing results

G

Gary's Student

I can't open your file. Make sure that the cells in which you want to place
formulae are not formatted as Text. Make sure your formulae start with the =
sign.
 
M

Morrigan

That is because the codes in sheet "Mo" are numbers and the codes in
sheet "SI-2" are not. You can easily check by using:

IF(NumberFromSheetMo=NumberFromSheetSI-2,1,0)

You will find that it returns 0. Thus they are not equal. That's why
your formula returns nothing.

To fix that, select the codes on sheet "SI-2" and go to:

Data -> Text to columns -> Finish


Hope it helps.
 
Top