incentive

Hello! I have a worksheet that has a list of times people are picking up extra hours. They get an incentive (-.50) if they work any three hours on Sunday(-.50); they get another incentive if they work between 0900-1300 (-.50), and/or 1830-2300 (-.50). The formula I have only works if they pick...

Hi everyone! Pleasure to have become a member of the community. I hope to become a net contributor to the board in the future. Alas, now I will posting (hopefully) pretty basic stuff. I mostly self-taught myself Excel and became pretty proficient from my former job in benefits (typical basic IF...

Hi, I have a delivery company and want to create an incentive tracking sheet. My drivers will start accumulating fixed commissions after a certain number of deliveries (below chart); <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody>...

Hi, Need help to find a suitable formula to make the calculation automatic based on the numbers they score for each heading. Please see the sample below. First table is the incentive matrix and the second is a sample score for agents. I need the total payout to be generated based on the...

<tbody> So I Have 3 sheets "Scale", "Incentive Calcs", and "Data" What I am trying to do here is to get a $/Direct value from Column R in sheet "Scale" into the sheet "Incentive Calcs", Column I based on each row's values from Columns G and H. Example formula from Cell I2 is this...

Dear team, I want to calculate below mentioned incentive data pls help. Sale is less than 15000 incentive is 30 Sale is 15001 to 25000 incentive is 60 Sale is more than 25001 incentive is 100 Thanks in advance Regards, Sureahraja.M

Hi, I was wondering if somebody could guide me with this problem I have. I am trying to create a worksheet to calculate an incentive/disincentive. Essentially it is like this: I have a vendor that I want to incentivize/disincentivize for finishing a project according to a deadline...

from 1 to 1000000 = 6% 1000001 to 1500000 = 7% 1500001 to 2000000 = 8% 2000001 to 2500000 = 9% 2500001 to 3000000 = 10% 3000001 to 3500000 = 11% 3500001 to 4000000 = 12% 4000001 to 1000000000000000000000000000 = 12% i need a formula to calculate the commision shown above in excel