Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement working only once | Excel Worksheet Functions | |||
IF Statement not working after pasting data | Excel Discussion (Misc queries) | |||
If Statement Not Working | Excel Worksheet Functions | |||
IF statement not working | Excel Discussion (Misc queries) | |||
Wildcard Not Working in IF statement | Excel Worksheet Functions |