Home » Forums » Open Source Learning Center » Question and Answer

Sales Comission Tracker with multiple "if"

Submitted by lionelcarlsen on 5 October, 2015 - 10:28

HI team I am working on a sales excel workbook that will help with trends, forcasting, comissions, daily targets etc. Stumbling through and I need some assistance with the below scenario and how to enter:

I have attached the workbook I have made from scratch.

Here is the formula I need help with:

if sales $0-$20,000 no commission,
if sales $20,000-$45,000 7.5% commission on all sales.
if sales >$45,000 - Budget 10% commission on all sales.
if sales >$45,000 + > combined budget 15% commission on all sales.

Local Market tab Cell C136-N136 are the cells that need to calculate and reference back to the landing page tab.

Happy to take advice on board and thanks in advance for any help or point me into a direction of where to learn and do what I need done.

AttachmentSize
Townsville Figure Tracker 2016.xls333 KB
‹ VBA to search column of letters and for that letter searched return letter below it to Help on understanding a formula an insurance administrator uses to calculate an annulized cash value ›
»

Formula

Submitted by Max F. on 9 October, 2015 - 22:05.

Put this formula in cells C136 and then drag it across:

Is this what you need? I wasn't sure if you wanted $20k to receive 0 or 7.5%. If you want 20k to receive 7.5% then change 20001 to 20000

Thanks!

 

-Max

»