IF Statement not working

[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.

 

[Dave]

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.

 

[Barrett M]

The valurs are two to three digit characters such as AB BC CD also _AB _BC _CD

Thanks again

 

[Barrett M]

Any Ideas?

The valurs are two to three digit characters such as AB BC CD also _AB _BC _CD

Thanks again

 

[Spiky]

Any Ideas?

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)

 

[David Biddulph]

Have you checked for spaces or other non-printing characters?
Use =LEN(E5) and =LEN(G5) to check whether the string is longer than you
expected.

 

[Barrett M]

That was it. E5 is 3 and G5 is 5. Is there a way to add or remove spaces?

 

[David Biddulph]

REPLACE function
SUBSTITUTE function
TRIM function
CLEAN function
Edit/ Replace.

 

[Barrett M]

Worked Great Thanks for your Help !!

REPLACE function
SUBSTITUTE function
TRIM function
CLEAN function
Edit/ Replace.