Forum Discussion
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 "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!
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.
You are welcome. I'm glad the suggestion is helpful.
