Forum Discussion
Formula for when one cell equals another cell & Resulting Cell is Yes
Alternative to the previous suggestion if Excel version is below 2016.
=IF(A2=B2, "Yes", "")
You can use an IF formula in cell C2. This formula will check if the content of cell A2 is equal to the content of cell B2 and, if so, it will display "Yes" in C2. If the contents are not equal, it can display something else or remain blank.
This formula is simple and works perfectly for comparing addresses or any other text content in cells.
Maybe it will help you in addition to the previous suggestion.
Happy Excel-ing!
Alternative to the previous suggestion if Excel version is below 2016.
=IF(A2=B2, "Yes", "")
You can use an IF formula in cell C2. This formula will check if the content of cell A2 is equal to the content of cell B2 and, if so, it will display "Yes" in C2. If the contents are not equal, it can display something else or remain blank.
This formula is simple and works perfectly for comparing addresses or any other text content in cells.
Maybe it will help you in addition to the previous suggestion.
Happy Excel-ing!
- Thanks. This worked perfectly.
Take care.
