How do I calculate a capped amount based on customer? For example, if the same customer has multiple deals for the year, commissions should only be paid on an annual capped amount of 250K even if the total is over 550, see example below.
Company Deals
A 100
B 200
C 150
A 200
A 250
I would like to cap Company A sales at 250. Please advise.
Much appreciated!
Perhaps something like =MIN(250,sumif(a2:a100,"a",b2:b100))
Duplicate post
http://www.excelforum.com/excel-gene...on-client.html
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
http://www.excelforum.com/excel-gene...on-client.html
Thread Closed.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks