software

I am trying to create a formula to calculate my commissions, but my
commissions aren't percentage based. The difference between my bill rate and
pay rate is the spread. If my spread is between $20 and $30, for example, I
get $500. If the spread is between $30.01 and $40, I get $1000, etc. So, the
higher the spread, the higher my commissions are. I have a spread sheet that
calculates my spread, but I'd like to track commissions also. Any ideas out
there?


I'd create a commission table as a couple columns, Spread and
Commission. Then next to your Spread calculation, you can place a
Vlookup which references the spread number and the commission table.
The table could be on a different worksheet if necessary.

See VLOOKUP under help.

---GJC--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=527839Thanks for the help. I've never created a commission table. Do you have a
simple explanation on how to do this?

quot;gjcasequot; wrote:

gt;
gt; I'd create a commission table as a couple columns, Spread and
gt; Commission. Then next to your Spread calculation, you can place a
gt; Vlookup which references the spread number and the commission table.
gt; The table could be on a different worksheet if necessary.
gt;
gt; See VLOOKUP under help.
gt;
gt; ---GJC
gt;
gt;
gt; --
gt; gjcase
gt; ------------------------------------------------------------------------
gt; gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
gt; View this thread: www.excelforum.com/showthread...hreadid=527839
gt;
gt;


By commission table, I just meant a table of the spreads versus
comissions, i.e., put the spreads in col A and the corresponding
commissions in Col B.

Example: (quot;Spreadquot; is in A1)

SpreadCom
0100
20500
30.011000
50.12000
100.15000

If your spread is in cell D1, then in E1 put =VLOOKUP(D2,A2:B6,2,TRUE)Spread = 35 ==gt; 1000

HTH

---GJC--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=527839