I need to be able to create an "if" function that will populate to a couple
other "if" functions within itself.

What I'm trying to do is get one cell to look at the information entered in
another one, and if that cell gets to a certain number, to change the
equation to watch for a new number in that cell.

Example: Employee group one gets a pay raise when he hits 10, 25, and 50
sales. Employee group two gets a payraise when he hits 15, 25, and 55 sales.
How do I set a cell to say what level (1, 2, 3) the person is at currently?