I need a formula in excel for my Salary slip ....!

Hello
Dears

I need a formula in excel for my Salary slip.
here is the details


If Total Salary >= 25000 and = 29999 then - Income Tax 6% of Total Salary
If Total Salary >= 30000 and = 34999 then - Income Tax 7% of Total Salary
If Total Salary >= 35000 and = 39999 then - Income Tax 8% of Total Salary


Thanks
Abdullah

If your salary is in A1 then you could try this formula:

=A1*CHOOSE(MATCH(A1,{25000,30000,35000},1),0.06,0.07,0.08)

However, you don't specify what you want to do if the salary is below 25,000 or above 40,000. This formula will return an error for a salary less than 25,000 and tax salaries over 40,000 at 8%. If you want it to do something different then let me know.

Try

=INDEX({0,0.06,0.07,0.08},MATCH(A1,{0,15000,30000,35000},1))

Thanks Andrew-R
your this formula is working in giving conditions but my salary starts from below 1,000 and maximum 100,000 here is the details
now can you give me final formula ?

If Total Salary >= 1000 and = 24999 then - Income Tax = 0% Total Salary
If Total Salary >= 25000 and = 29999 then - Income Tax = 6% Total Salary
If Total Salary >= 30000 and = 34999 then - Income Tax = 7% Total Salary
If Total Salary >= 35000 and = 39999 then - Income Tax = 8% Total Salary
If Total Salary >= 40000 and = 45999 then - Income Tax = 9% Total Salary
If Total Salary >= 45000 and = 49999 then - Income Tax = 10% Total Salary
If Total Salary >= 50000 and = 54999 then - Income Tax = 11% Total Salary
If Total Salary >= 55000 and = 64999 then - Income Tax = 12% Total Salary
If Total Salary >= 65000 and = 100000 then - Income Tax = 14% Total Salary

OK, you can just expand my formula:

=A1*CHOOSE(MATCH(A1,{0,25000,30000,35000,40000,45000,50000,55000,65000},1),0,0.06,0.07,0.08,0.09,0.1,0.11,0.12,0.14)

However, you're reaching the point where it may be easier to set-up a look-up table in another group of cells and use VLOOKUP to return the tax rate.

Big Thanks Andrew-R
its working