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