Forum Discussion

ukusprof's avatar
ukusprof
Copper Contributor
Jun 22, 2022
Solved

Need to return a text result if info in 3 cells = Complete

Hi -  I'm struggling with how to set up a formula to automatically return a "Yes" or "No" in a column, based on whether the previous three cells in the row are marked as "Complete," "Passed" and "Co...
  • OliverScheurich's avatar
    Jun 22, 2022

    ukusprof 

    =IF(AND(A2="Complete",B2="Passed",C2="Complete"),"Yes","No")

    Maybe with this formula.