I'm trying to set up a database and set up different alerts/flags if data is not entered in certain cells. For instance, if data is entered in cell one but not in cell two, I want one alert but if data is not entered in either, a different alert.
At the moment, I have tried to use this:
=IFS(C2="*", "Plant", E2="","Support")
Support is showing up correctly, but Plant is not. Any thoughts?
Aucun commentaire:
Enregistrer un commentaire