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...b/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" wrote:

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
--
Life isa journey not a destination