If Formula displays error message
 

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

If Formula displays error message
 

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

If Formula displays error message
 

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


"Mike H" wrote:

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

If Formula displays error message
 

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

--
Life isa journey not a destination


"Mike H" wrote:

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