jeudi 18 février 2016

Excel IF Statement with 4 conditions

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