Tiered Commission

Hello all! I need help on a lengthy "what if" formula. I have to calculate commission based on $x-$xx = 1% of gross profit, $xx-$xxx = 2% of gross profit, etc. Are any of you able to assist me? I have no idea what to do.

Something like:

Formula:

Please Login or Register  to view this content.

Nor do we without seeing a sample of your data .... but I am sure we can help.

Please see yellow banner at top of page of how to attach a sample workbook, which should include some manually-calculated results

try this:

=SUMPRODUCT((A7>$E$2:$E$7)*(A7-$E$2:$E$7)*($F$2:$F$7-N(+$F$1:$F$6)))

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new here, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!

Regards,

Glenn.

Thanks for the rep.