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

[ukusprof]

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 "Complete" respectively. E.G.:

Training	Assessment	TDR	Overall Complete
Complete	Passed	Complete	Yes
Complete	Failed	Incomplete	No

Furthermore, possible responses for each column are as follows:

Training: Registered, Not Started, In Progress, Complete

Assessment: Registered, Not Started, Passed, Failed

TDR: Registered, Not Started, In Progress, Complete

I'm sure this is an easy formula for some of you, but I can't seem to figure it out. Can anyone help?

I did try to search the forum and wasn't able to pinpoint a similar example. Sorry if I missed anything!

TIA!

[#2 · Accepted solution]

@ukusprof 

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

Maybe with this formula.

 

[#3]

@OliverScheurich , Thank you so much! Worked brilliantly, and now I've learned how to do something like this. Really appreciate the time you took to help me.

[#4]

@ukusprof 

You are welcome. I'm glad the suggestion is helpful.