| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Take a look he
http://www.mcgimpsey.com/excel/variablerate.html In article , "Asta" wrote: Ok here is what i have i have created a payroll. now i need to add this: if pay is $0 - $95 deduct $0 plus 0c per dollar over 0 if pay is $96-$345 deduct $0 plus 20c per dollar over 96 if pay is $346-$480 deduct $63 plus 25c per dollar over 346 if pay is $481-$672 deduct $96 plus 40c per dollar over 481 if pay is $673-$961 deduct $183 plus 47c per dollar over 673 if pay is $962+ deduct $308 plus 48c per dollar over 962 And make it automatically deduct from the Gross Income. I have tried this =IF(C4300,C4<400,(C4-43)*0.36,IF(C4401,C4<500,(C4-60)*0.45,IF(C4501,<600,(C 4-200)*0.60))) (numbers were just to try out) and it didnt work. How would i go about creating such a formula? or is there a different way of handling it? |
Threaded Mode
