| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function question
The two columns I am comparing are text. In another column I have this: =IF(G5=O5,1,0) As an example, I have "237A98" in the same row in G5 and O5 but when I evaluate this function it brings back '0', not '1'. Anyone know why? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function question
Could additional spaces be a problem?
Try this =(TRIM(G5)=TRIM(O5))*1 Mike "scubadiver" wrote: The two columns I am comparing are text. In another column I have this: =IF(G5=O5,1,0) As an example, I have "237A98" in the same row in G5 and O5 but when I evaluate this function it brings back '0', not '1'. Anyone know why? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function question
duh! thanks for pointing out what wasn't very obvious. "Mike H" wrote: Could additional spaces be a problem? Try this =(TRIM(G5)=TRIM(O5))*1 Mike "scubadiver" wrote: The two columns I am comparing are text. In another column I have this: =IF(G5=O5,1,0) As an example, I have "237A98" in the same row in G5 and O5 but when I evaluate this function it brings back '0', not '1'. Anyone know why? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function question | Excel Worksheet Functions | |||
| IF function question | Excel Worksheet Functions | |||
| Function question | Excel Discussion (Misc queries) | |||
| Function Question | Excel Worksheet Functions | |||
| Function question | Excel Worksheet Functions | |||
Hybrid Mode
