View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim
 
Posts: n/a
Default Not sure what type of Formula to use...

I am working on an "experience" bonus for my sales reps. For every new sale
they make, the salesman's commision goes up .1% (one 10th of a percent) up to
their 50th sale which would be 5.0%. Can someone help me with a formula for
this?
Thank you very much!!!