Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I have error message when formula is over value? | Excel Worksheet Functions | |||
Error message #NAME from formula | Excel Discussion (Misc queries) | |||
Error message #NAME from formula | Excel Worksheet Functions | |||
Formula Error Message | Excel Discussion (Misc queries) | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |