mercredi 15 novembre 2017

Google sheets, if statement multiple conditions

Trying to make an if statement that will return 4 outcomes based on the contents of the cell

If the cell is "Yes", "No", "NA", "Unknown", to return 0, 1, 2, 3,

I can get If(A1="Yes", 0,1) but not sure how to handle the other conditions

Aucun commentaire:

Enregistrer un commentaire