Hi Guys,
I have attached a spreadsheet which shows my desired result which often helps.
Range C2:C13 is my desired result...
The problem /criteria is...
For every 140 meters sold the sales person receives £140 commission.
Meters (range B2:B13) can be carried to future months.
I am looking for a formula for range C2:C13 which calulates if commission should be paid in this month or not and if so, how much.
Many thanks for taking the time to help
Last edited by Blake 7; 02-26-2014 at 05:26 PM.
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Do they receive £140 or £400??
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
You may try:
=INT(SUM(B$2:B2)/140)*400-SUM(C$1:C1)
(I assume 400, not 140, commission)
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
darn! Hi Tiger, hope you are well, long time!
$400 for every 140 meters..... they are making a killing!!
In that case, Izandol's formula should work for you
Hi guys - many thanks for looking. Tiger, good to see you are still around dude!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks