commission % for 90 days

  • Thread starter Thread starter MathewS
  • Start date Start date
M

MathewS

Here's one for ya!
I have a commission spreadsheet, and i neeed to be able to
have a special commission (30%) for all "new accounts",
for a set length of time. So i get a New Account, and for
next 90 days, on each order from that account, i get 30%.
This hurts my brain.
 
Quick and dirty:

Say you put the date that you acquired the new account in A1, and your
regular commission is 15%, and the sales amount total is in B1, then try:

=IF(A1+90>TODAY(),B1*0.3,B1*0.15)

DIRTY because Today() is volatile, so 90 days from now, your commission is
reduced UNLESS you remove the formula from the cell after computation and
leave behind the value by right clicking in the cell and choosing "Copy",
then right click again and choose "PasteSpecial" and then "Values", and then
OK.

HTH

RD
 
that'll do it for me. thanks!
-----Original Message-----
Quick and dirty:

Say you put the date that you acquired the new account in A1, and your
regular commission is 15%, and the sales amount total is in B1, then try:

=IF(A1+90>TODAY(),B1*0.3,B1*0.15)

DIRTY because Today() is volatile, so 90 days from now, your commission is
reduced UNLESS you remove the formula from the cell after computation and
leave behind the value by right clicking in the cell and choosing "Copy",
then right click again and choose "PasteSpecial" and then "Values", and then
OK.

HTH

RD






.
Click to expand...
 
Back
Top