I have a spreadsheet where I want to populate a cell to indicate if three conditions are met from ranges of other cells. Users must complete one of two Interest Badges (B4:C4), one of four Skills Builders (D4:G4) and 3 hours of other activities (H4). Cells are populated with a "1" if complete, a "0" if not complete and are populated as IF functions referring to other worksheets within the same file.
In cell I4, I want it to put a "Y" if all three conditions are met. But to leave it blank if one or more conditions are not.
I am googling but struggling with exactly how to word my question on google and I have tried various methods. So far, I've had no luck.
Is this possible? If so can anyone help please?
Aucun commentaire:
Enregistrer un commentaire