Commissions Calculator

[jswillcox]

I would appreciate some help with automatically calculating commissions.

How can I have it reflect a specific number when I have numbers within a field. ex

0 - 88 = 0%
89 - 97 = 50%
98 - 106 = 75%
107 - 115 = 100%
116 - 124 = 125%
125 - 133 = 150%
134 - greater = 200%

This will only be dealing with whole numbers or units sold.

In addition I am working on making a pacing section.
I know I can add the value in for the remainder of days left in the quarter. Is there any way to automate that?
The equation I would use is (Lines Sold/Days in quarter to date)*total days in quarter
I could add it manually, I was just hoping excel could put the days in quarter and total days left in the quarter automatically.

Thank you for your help!

 

[jswillcox]

=lookup(a2, date(year(a2), {1,4,7,10}, 1), date(year(a2), {4,7,10,13}, 1)) - lookup(a2, date(year(a2), {1,4,7,10}, 1))

That did it! Thank you again!

 

[shg]

You're welcome.