Need formula that would calculate the following:
Scenerio: $69,000,000 in sales ( Cell A)
Commission( Cell B): .25% for 1st $50MM / .30% for amount between $50MM-
$60MM /.35% on amounts over $60MM

The value in cell B should be $ 186,500 ( $125,000 for 1st $50MM, $30,000 for
next $10MM, then $31,500 for the remainder $9MM