IF Statement not working
 

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.

IF Statement not working
 

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" wrote:

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.

IF Statement not working
 

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

Thanks again

"Dave" wrote:

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" wrote:

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.

IF Statement not working
 

Any Ideas?

"Barrett M" wrote:

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

Thanks again

"Dave" wrote:

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" wrote:

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.

IF Statement not working
 

On May 5, 3:25 pm, Barrett M
wrote:
Any Ideas?

"Barrett M" wrote:
The valurs are two to three digit characters such as AB BC CD also _AB _BC _CD

Thanks again

"Dave" wrote:

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" wrote:

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.

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)

IF Statement not working
 

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.
--
David Biddulph

"Barrett M" wrote in message
...
Any Ideas?

"Barrett M" wrote:

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

Thanks again

"Dave" wrote:

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" wrote:

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.

IF Statement not working
 

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

"David Biddulph" wrote:

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.
--
David Biddulph

"Barrett M" wrote in message
...
Any Ideas?

"Barrett M" wrote:

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

Thanks again

"Dave" wrote:

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" wrote:

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.

IF Statement not working
 

REPLACE function
SUBSTITUTE function
TRIM function
CLEAN function
Edit/ Replace.
--
David Biddulph

"Barrett M" wrote in message
...
That was it. E5 is 3 and G5 is 5. Is there a way to add or remove spaces?

"David Biddulph" wrote:

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.
--
David Biddulph

"Barrett M" wrote in message
...
Any Ideas?

"Barrett M" wrote:

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

Thanks again

"Dave" wrote:

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" wrote:

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.

IF Statement not working
 

Worked Great Thanks for your Help !!

"David Biddulph" wrote:

REPLACE function
SUBSTITUTE function
TRIM function
CLEAN function
Edit/ Replace.
--
David Biddulph

"Barrett M" wrote in message
...
That was it. E5 is 3 and G5 is 5. Is there a way to add or remove spaces?

"David Biddulph" wrote:

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.
--
David Biddulph

"Barrett M" wrote in message
...
Any Ideas?

"Barrett M" wrote:

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

Thanks again

"Dave" wrote:

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" wrote:

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.