sliding scale

I'm having a brain fart. How do I write a formula that calculates the percentage of bonus payout based on the picture/table below? If the quota sold is less than 96 widgets, there is no bonus If you reach 96 widgets you immediately receive 50% of your bonus. Prorate the bonus with a linear...

Sorry. I know there is a simple solution to this and I’m just blind to it. Calculating Sliding Scale Percentage Current Formula in cell A46 =IF($B$33<5000,”.007”,IF($B$33<10000,”.006”,IF($B$33>9999,”.005”,””)))*10 This works perfect, however I need this formula to consider the value of A43...

Hello, I could use some help with a sliding scale formula. I need a formula that does the following: if a sales rep achieves 85% of sales, they will achieve 50% of their bonus. If a sales rep achieves 100% of sales, they achieve 100% of their bonus. If they achieve 115% of sales, they’ll get...

Hello Everyone, I'm trying to work out the commission made on a total So for example: Cell U54 is the total commission. Then in Cell T57i would like it to work out the first £5000 at 12.5% Then in cell T58 i would like it to work out 5000-9000 at 15% Then in cell T59 i would like it to work...

I'm using Excel 2010. I'm working on sales commissions & bonuses. The commission part is easy – just multiply the cell w/ the sales number times the commission rate (as an absolute reference). I'm stuck on our sliding scale for bonuses. For example: IF sales >=120,000, bonus =2.5% IF sales...

I am new here so first of all I just want to say hello to everyone. I'm trying to incorporate a slinding scale into an excel spreadsheet so a column will be automatically populated based on a value in a seperate cell. The scale I am incorporating is as follows <TABLE style="WIDTH: 163pt...

A B 1 Name Bookings 2 Integis $10,500 3 ABC Company $17,500 4 Today Company $30,000 5 anuary $58,000 Booking Scale Commission payout $15,000.00 10% $36,000.00 15% $45,000.00 20% $56,250.00 25% How would...