Compare two cells with text (1 Viewer)

[echorley]

How do I compare two cells in a spreadsheet with each other using the IF statement. For example: =IF(A2 = B2, "Yes", "No") always gives me No eventhough A2 = C and B2 = C (both contain an upper case C).

 

[ajetrumpet]

How do I compare two cells in a spreadsheet with each other using the IF statement. For example: =IF(A2 = B2, "Yes", "No") always gives me No eventhough A2 = C and B2 = C (both contain an upper case C).

TRY refreshing the page with F9. maybe also check the cell type? cell formatting? try it in other cells too...to narrow down the problem cells...

 

[HaHoBe]

Hi, echorley,

additional spaces?

=IF(TRIM(A2)=TRIM(B2),"Yes","No")

Ciao,
Holger

 

[Access Hero]

Also try trimming the values. Like this:

=IF(TRIM(A2) = TRIM(B2), "Yes", "No")