Creating IF statement with multiple conditions that WORKS

Can someone spend a little time going through a relatively easy IF statement with me with multiple conditions?

Tried everything I can to make this work - it seems pretty simple but OMG can I not get it to do anything! What's the best way? Any help is appreciated! I can send examples if need be.

Thanks, Cherry