lundi 19 août 2019

Google Sheets Ifs Statement: Only Counting One Logical Expression

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