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