Formula Calculation

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

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

The value in cell B should be $ 186,500 ( $125,000 for 1st $50k, $30,000 for
next $10K, then $31,500 for the remainder $9K)
 
Need formula that would calculate the following:
Scenerio: $69,000,000 in sales ( Cell A)
Commission( Cell B): .25% for 1st $50,000 / .30% for amount between $50,000-
$60,000 /.35% on amounts over $60,000

The value in cell B should be $ 186,500 ( $125,000 for 1st $50k, $30,000 for
next $10K, then $31,500 for the remainder $9K)
Click to expand...

Cell A? Cell B?
Sounds like an Excel problem.

You have posted this question to the wrong newsgroup.
The access in this groups title refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the program you are using.
I would suggest you include your Windows and Office version number in
your message. It might make a difference.
 
Paying $125,000 commission for $50,000 in sales doesn't really make sense.

no it doesn't, Linq, but i want that job! <g>
 
Back
Top