vendredi 9 mars 2018

Excel Insert text depending on answer

I have an excelsheet with dropdown answer from cell D8 and down in D. The choices are "Medium", "High", and "Very high". Im trying to figure out a way to do the following:

1) If D8 is medium leave the cell N8 empty
2) If D8 is High then write irrelevant in N8
3) If D8 is Very High then write "Call Person on phoneXXX" in N8

I have tried to use a normal IF statement, but I can't find a way to leave the cell empty if D8 is Medium so I have a feeling that privatesub is the way to go.

Aucun commentaire:

Enregistrer un commentaire