Variable function

  • Thread starter Thread starter ESP Tom
  • Start date Start date
E

ESP Tom

Hi,

I'm a sales manager that has a team with a variable rate of commission
They either make telesales or sales through an appointment. If they mak
more than £5000 in telesales their commision goes up from 5% - 10%. A
the moment I use a referenced worksheet on my machiene that draws o
spreadsheets on the company file. I can programme the sheet to work ou
the percentage if it's set at 5% but is it possible to make it vary i
the telesales value goes above £10'000
 
You could consider having a cell on your sheet which contains an I
function where the volume of telesales triggers 10% or 5%.

You could then reference the value of this cell for your comissio
calculations
 
Back
Top