CODEWITHSUNDEEP
arraysexcelif-statementexcel-formula
flyers
flyers

Reputation: 514

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.

Upvotes: 0

Views: 1452

Answers (1)

Scott Craner
Scott Craner

Reputation: 152465

Since it is from a drop down and the only thing that changes is the second word. Try this:

=IF(B1<>"", "Complete " & B1 & " Section")

If you want the big nasty formula:

=IF(B1="Report","Complete Report Section",IF(B1="HLE","Complete HLE Section",IF(B1="Enhancement","Complete Enhancement Section","")))

Upvotes: 2

Related Questions