If Formula displays error message

[Sherees]

Hi
This was the formula IF(J16=J19,"RIGHT","WRONG") and the column j16=j19 but
the messgae displayed was wrong instead of right when i pasted the same
formula in other cells and tested and it works. Is it because that the cell
J16 & j19 was with formula which linked to other sheets. Please show the light

Thanks

 

[Mike H]

Hi,

It may be that the values in J16 & J19 'look' the same because of the way
they are displayed but in fact may be slightly different. Maybe something
like this

=IF(ROUND(J16,2)=ROUND(J19,2),"RIGHT","WRONG")

And as for why it happens, have a look here

http://support.microsoft.com/default.aspx/kb/214118/en-us
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Sherees]

the formula is not changing when i entered idfferent numbers in j16 & j19,
but when i put the same formula in other cell its working perfectly. But in
my other xl file this was working perfectly well. I also checked the formula
calculation, its in automatic mode. so what is the error due to

 

[Sherees]

Sorry that was an erro from my side, now its working, thanks a lot