Hi everyone;

I really need help, I've looked everywhere and I can't seem to find
anything that has all that my boss is wanting to do! Typical


My boss is looking for a formula that will be able to calculate the
following.

Sales Commision by rep

E.G.
3% of sales up to 99.99% $_____
5% of sales up to 100% - 109.99% $______
10% of sales up to 110% - above $______

It will be based on the targets that he sets the reps per month.

If anyone has any ideas I would be so gratefull.

Thanks for taking the time to think my request through

Sarah


--
spunkysezza
------------------------------------------------------------------------
spunkysezza's Profile: http://www.excelforum.com/member.php...o&userid=31921
View this thread: http://www.excelforum.com/showthread...hreadid=516475