commission percentages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi
im working on a project for school
I need the formula to figure out the commission for the following
projected sales amounts
3.25% of $542,413.00
$ 823,912.00
$362,750.00
$622,165.00
$ 750,450.00
Thank You!
 
Assume you have 3.25% in A1 and the amounts are in B1"B5, format C1 as
currency and put this formula there

=$A$1*B1

copy down to C5
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sales Commission Rates 4
Formula to obtain result from non exact sequence match 2
Lookup / Array Range / find the value 4
Help Needed : how do i compute this? 0
How to make "If,then" formulas with THREE outcomes 4
Excel - Commission using SumIF 0
Sales Commission Calculation 3
Circular Reference for Commission % 1

Back
Top