jeudi 24 mai 2018

Formula to fulfil 3 conditions

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