Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simplify my life with if...
I have to pay at the end of this year the bonus to my external reps. Their
bonuses are paid on a range of values and I need to adjust the % that they will be paid at the end of the year in accordance to this range. How can I do this without actually going one by one and modifying the amount? ex: if rep has 100% of budgeted sales: he gets 100% of his yearly bonus, if rep has 100,1%,-104.9%: prorata of bonus, 105%-109,9%=125% of bonus....the maximum is +130%: 200% of bonus. Is it possible to this? I succeed partially with =if.... -- Thanks! Rosie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How to simplify this IF formula | Excel Worksheet Functions | |||
Money for life | Excel Worksheet Functions | |||
Money for life | Excel Discussion (Misc queries) | |||
Simplify Linking to several worksheets?? | Excel Worksheet Functions |