Thread: IF function question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scubadiver scubadiver is offline
external usenet poster
  
Posts: 55
Default 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?

Reply With QuoteReply With Quote