I would like to write a formula that uses more than two variables for an expression, I've attached a spreadsheet to show what I'm thinking of. I had been using nested IF statements to make things like that work, but I'm hoping that with the more recent releases of Excel that there is something simpler that can do the same thing.

Here's what I have
Managing multiple variables.xlsx