Auto-populate text based on value of two columns separately

I'm trying to figure out how I can change the text in Column E based on Column B and Column D. I have only been able to use the IF function based on Column D. But what I really need is:   If there ...