I’d like some help with a formula that can do the following:
Cell A1 : Participation Type (Leader or Member) Cell A2 : Full Name Cell A4 : output cell
1) if cell A1 is empty, return empty in cell A4 2) if cell A1 is not empty, and cell A1 has “Leader”, return A2 + (Leader) 3) if cell A1 is not empty, and cell A1 does not have “Leader”, return A2 in cell A4
I’m very bad with logical functions that has 3 or more conditions. Any assistance will be much appreciated! Thank you!
Aucun commentaire:
Enregistrer un commentaire