I need help with what I think is a Vlookup issue. I am trying to develop a sales commission schedule
that pays, as an example, 45% of gross commission up to $35000; 50% to $45,000; 55% to $65,000...up
to 80% in 5% and $10,000 increments. Commissions are listed and paid depending on where they fall as
they build year to date (YTD) subtotals. For example, sales agent has earned YTD commissions of $34.000;
now has a sale with a $2,000 commission. I have developed a schedule which simply pays on the last
level reached on the schedule, but I need a formula that will now pay $1,000 of the commission at the
45% level and then $1,000 at the newly reached 50% level. I'd appreciate a model that would accomodate
this situation. Thanks very much in advance.
that pays, as an example, 45% of gross commission up to $35000; 50% to $45,000; 55% to $65,000...up
to 80% in 5% and $10,000 increments. Commissions are listed and paid depending on where they fall as
they build year to date (YTD) subtotals. For example, sales agent has earned YTD commissions of $34.000;
now has a sale with a $2,000 commission. I have developed a schedule which simply pays on the last
level reached on the schedule, but I need a formula that will now pay $1,000 of the commission at the
45% level and then $1,000 at the newly reached 50% level. I'd appreciate a model that would accomodate
this situation. Thanks very much in advance.