PDA

View Full Version : Formula for job


Hammdy
Jul 19, 2008, 01:15 PM
I'm looking for an excel formula to help in my job , I've been working on it for ages , so please send the form to my email [email protected] your help is needed. Eg: I have a salary of xxxxx ( pounds ) I need to deduct 5% for the first 3000 p , and 7% for the next 4000p , and 9% for the last 4000 pounds. ( did you get it , its deduction for the medical insurance thing I have in my company ) feedback , I've tried combining the %% but didn't work.:confused: :confused:

mdosh01
Jul 20, 2008, 02:12 PM
If I understand correctly, the formula you are looking for would be as follows. Assume the salary is in cell A1. Then the deduction is:

=IF(A1<3001,A1*0.03,IF(A1<4001,A1*0.07,IF(A1>4000,A1*0.09,"error")))

This is just one approach that will work. Note that it does not account for a negative salary.

JBeaucaire
Jul 21, 2008, 06:15 AM
The attached breaks out your salary into portions and applies the required percentages. If the salary is different than £11,000.00 you can edit that field. The last section will always include everything above £7,000.00

You can also adjust the percentages and the w/h will correct.