Ask Experts Questions for FREE Help !
Ask
    Hammdy's Avatar
    Hammdy Posts: 3, Reputation: 2
    New Member
    		  
    #1

    Jul 19, 2008, 01:15 PM
    Formula for job
    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's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
    		  
    #2

    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's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    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.
    Attached Files
  1. File Type: xls SalaryIns.xls (14.0 KB, 170 views)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to put this in a formula [ 1 Answers ]

This is what I have so far: 0.2*W + 0.6*J = 0.44*x Wilson High School has 400 students, of whom 20% are African American. The school board plans to merge Wilson High with Jefferson High. This one school will then have a student population that is 44% African American. If Jefferson currently has...

What is the formula [ 1 Answers ]

Hello What would you pay for an annuity of $2,000 paid every six months,beginning in 6 months, for 12years if you could invest your money elsewhere at 10% compounded semiannually? How would this change if those payments began immediately?

NE 1 know what this formula is for [ 8 Answers ]

E=2= +a+b E is Epsolon symbol B is Beta symbol It was on Treasure map from 1800's LOOK UPPER left corner area

Need a formula: [ 4 Answers ]

(This isn't homework, its part of a puzzle, and its got me stumped) I have 2 known numbers, n and z. They relate thus: n=x*y z=(x-1)*(y-1) n-z=x+y-1 I need to find x and y. Any ideas?

View more questions Search