IF function question

[scubadiver]

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?

 

[Mike H]

Could additional spaces be a problem?

Try this

=(TRIM(G5)=TRIM(O5))*1

Mike

 

[scubadiver]

duh!

thanks for pointing out what wasn't very obvious.