Excel Formula with Specific AND-Logic Outcome

I need a Excel formula that considers four different criteria. The criteria must interact with each other-- all four must be met (AND logic) in order to return a specific predetermined value (6 result values are possible dependant on the four variable inputs). The formula does not need to handle errors or unexpected values in the criteria, as it will always deal with perfect inputs.

- Must Have Skills & Experience:
- Advanced Excel skills
- In-depth understanding of Boolean logic
- Experience with Excel's 'IF' function and 'AND' operator