Hello, I'm new here and would like help making an excel calculator for the following. Thanks in advance.
Sales / Commission
0 to $25,000 / 10%
$25,000 to $50,000 / 20%
$50,000 to $100,000 / 30%
$100,000 + / 40%
An example is if someone sells $40,000 they would get paid $2500 + $3000 = $5500. Hope that's clear.
Try:
Please Login or Register to view this content.
Quang PT
Thank you nevermind
Last edited by bmc1492; 01-03-2014 at 12:54 PM.
Hi and welcome to the forum
Does "nevermind" mean that your question is no longer valid, of that you figured it out for yourself? If you found the answer, it would be great is you could share with the forum, so other members might benifit?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The answer that Bebo021999 posted works perfectly. Thank you. I thought there were initially some problems with the formula, but after playing with it some more I realized that it was working, so that's why I posted nevermind when I edited my reply. Sorry for any confusion.
Nice to hear it works and thank for your feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks