IF Statement not working

  • Thread starter Thread starter Barrett M
  • Start date Start date
B

Barrett M

My formula IF(E5<>G5, "Not Equal", "Equal") will only give the message "Not
Equal" even if the values are equal, however if i copy the formula into a new
worksheet and the values are equal it will return the Correct value of
"Equal".
Thanks for your help.
 
Hi,
If either E5 or G5 is a calculated value, there may be hidden decimals
present.
ie, the cell may display 123 but the actual value may be 123.000056
Dave.
 
The valurs are two to three digit characters such as AB BC CD also _AB _BC _CD

Thanks again
 
Any Ideas?
Click to expand...

I seem to say this often.

Is this a file that was created in a different version of Excel than
you currently use? All sorts of stupid things like this happen.

Regardless, and you already said this works, the answer is probably:
Select All
Copy
Paste (in new file)
 
Back
Top