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