If Then Formula Range

[renegade83]

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

[daddylonglegs]

try

=lookup(a1.{0,7,11,16;20,30,40,50})*a1

[renegade83]

gave an error on the

a1. part

[martindwilson]

look here
http://www.excelforum.com/excel-work...ml#post1970037