coreybryant
asked on
Formula for Configuring Commission
Attached is a spreadsheet with volume, net, transactions, commissions. The commission is 50% of the transactions.
But as you can see, there is different percentages. I don't know if I could get some type of average based on these numbers? I have more numbers that I can provide if needed, but I more numbers if needed.
Thank you!
eamples.xlsx
But as you can see, there is different percentages. I don't know if I could get some type of average based on these numbers? I have more numbers that I can provide if needed, but I more numbers if needed.
Thank you!
eamples.xlsx
I'm not sure I understand your question. The spreadsheet you attached shows that the commission column is 50% of the Net column. Where is your reference to differing percentages? You want net to calculate different commissions other than 50%?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am trying to get just get some type of average..It's difficult to say, column A, could (is) a percentage (usually between 1.69 - 3.09% (could be a bit more). Column B is between $0.20 - $0.40.
So if I go to F3 and use =SUM(A3/C3) and complete that formula all the way down, I get anywhere from 15 to 268.
I knew I should have taken Algebra II as my third math credit instead of Computer Math in high school :) - So I don't know if I am missing something. I should not have given (or rather put column D on there. I am just trying to see if there is a decent formula to figure out Column C.
In the first one, I know that there was one transaction for 88.88
I actually remembered and added $8.00. And used: =SUM(((A2*0.0169)+0.3)+(C2 /2)) - came close to the Net. I am pretty close to that one - just off by $0.10.
I am just wondering if there is some type of "guesstimate" to push on thru with this
Thank you!
examples.xlsx
So if I go to F3 and use =SUM(A3/C3) and complete that formula all the way down, I get anywhere from 15 to 268.
I knew I should have taken Algebra II as my third math credit instead of Computer Math in high school :) - So I don't know if I am missing something. I should not have given (or rather put column D on there. I am just trying to see if there is a decent formula to figure out Column C.
In the first one, I know that there was one transaction for 88.88
I actually remembered and added $8.00. And used: =SUM(((A2*0.0169)+0.3)+(C2
I am just wondering if there is some type of "guesstimate" to push on thru with this
Thank you!
examples.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! I was watching Criminal Minds as Penelope was wishing she had paid more attention LOL I took a look at the spreadsheet - that should help me out with one of my projects that I have been wanting to do
ASKER
Thanks again - I knew there was something that was there, just was hoping someone on here would know it :)