You can also try the below using LOOKUP..(just a formula)

=IF(A1="","",LOOKUP(A1,{0,30.01,40.01,50.01,70.01, 99.99,119.99,139.99},{190,250,275,300,315,320,370, 450}))

If this post helps click Yes
---------------
Jacob Skaria


"Keith D.B." wrote:

Im trying to create a worksheet to let me enter a dollar amount in a cell and
have Excel figure where it falls between and puts the correct dollar amont in
another cell. Basicaslly this is a commisson grid for my employees. I want to
take employee A's sheet and put a date and sales amount and Excel figure his
pay.
Here's an example:
$139.99 & up = $450.00
$119.99 €“ $139.98 = $370.00
$99.99 €“ $119.98 = $320.00
$70.01 €“ $99.98 = $315.00
$50.01 €“ $70 =$300.00
$40.01 €“ $50 =$275.00
$30.01 €“ $40 =$250.00
$0 €“ $30 =$190.0