I have drop down list in excel that when something from the drop down is selected the cell below displays a value.
I can get the following to work but when I try to add a fourth value it errors out.
What am I missing or need to do different?
=IF(B1="Report","Complete Report Section",IF(B1="HLE","Complete HLE Section",""))
I need to add a IF B1= Enhancement, Complete Enhancement section but for some reason I can not.
Aucun commentaire:
Enregistrer un commentaire