I'm looking for an If Then Formula that checks for numbers in a certain range and spits out the correspoding number. Thanks in Advance.

If John sells 6 units, then $20/unit.
If John sells 12 units, then $40/unit and so on.

Here are the ranges:

0-6 $20.00
7-10 $30.00
11-15 $40.00
16+ $50.00