Forum Discussion

markzullig's avatar
markzullig
Copper Contributor
Aug 24, 2024

Formula for when one cell equals another cell & Resulting Cell is Yes

Need a formula of when one cell equals another cell (i.e. address), then the third cell automatically populates the text "Yes".

 

Example:  A2 Cell equals B2 (A2 & B2 are address text content) which results in C2 being "Yes".

 

Thanks

  • markzullig 

    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!:smile:

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    markzullig 

    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!:smile:

Resources