Question about Microsoft Excel for PC

Variable tax rates in Excel

Hello all
How do I write a formula that will do the following - If taxable income is:

\$0-\$6000, tax is nil.
\$6,001 - \$21,600, tax is 17c for each \$1over \$6,000.
\$21,6001 - \$58,000, tax is \$2,652 plus 30c for each \$1over \$21,6000.
\$58,001 - \$70,000, tax is \$13,572 plus 42c for each \$1over \$58,000.
Over \$70,001, tax is \$18,612 plus 47c for each \$1 over \$70,000.

So, if I work on \$69,6000 as taxable income,....Help!

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotĀ 5 achievements.

Vice President:

An expert whose answer gotĀ voted for 100 times.

Sniper:

An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

• Expert

Hi there

Here you go!
NOTE:
1) Cell A8 mentioned here can be changed according to the cell where you want the input.
2) Change the Cell Formatting of the input and output cell to Currency so that you can see the \$ symbol.

=IF((A8<=6000),0,IF(AND(A8>=6001,A8<=216000),(((A8-6001)*17)/100),IF(AND(A8>=216001,A8<=58000),((((A8-216001)*30)/100)+2652),IF(AND(A8>=58001,A8<=70000),((((A8-58001)*42)/100)+13572),IF(A8>=70001,((((A8-70001)*47)/100)+18612))))))

Please let me know if you have any more queries

All the Best.

Posted on Feb 22, 2008

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

What is the formula to key in for negative, non-taxable?

Depending on your model usually enter Zero for non tax, and 1 for tax

Jan 30, 2016 | Retail Supplies

I need a formula to calculate sales tax. the tax caps at \$300 dollars.

=IF((A1*7.5%) > 300, 300, A1*7.5%)
• IF Sales Amount * Tax Rate is greate than \$300 then make it \$300 no matter what the value is.
• IF Sales Amount * Tax Rate is less than \$300 then make it the value of Sales Amount * Tax Rate.

Sep 29, 2015 | Microsoft Office Excel 2003 for PC

How are taxes, if any, calculated in a pro forma?

I assume that you are creating a pro-forma for others to use. Very simply, you could offer a cell that asks the user to nominate the applicable tax rate for their tax jurisdiction, or, if you know (or assume the value), place that into a cell then multiply the taxable amount by 1+the tax rate, ie I buy shoes for \$4 and have a 10% tax rate. Multiply the price of the shoe by 1.04 and you have the final price, inclusive of taxes.

Usually all fees and charges are applied before the taxes are calculated., but check your local tax rules because some government levied charges may not be taxable.

Aug 31, 2014 | Microsoft Excel for PC

What is ot tax code

"OT" is used when your allowances have been used up or reduced to nil and your income is taxed at the relevant tax rates. May also be used if you've started a new job and don't have a form P45 or haven't completed a Starter Checklist or provide your employer with relevant information before your first pay day

May 01, 2014 | Computers & Internet

Hello, TAX-AMT is not printingon receipt after changing tax rate.

Go back to system options and print options and select PRINT TAXABLE or TAX AMOUNT

Jan 04, 2013 | Casio TE-2000 Cash Register

What is mean by tax and service tax

TAX:

A fee charged ("levied") by a government on a product, income, or activity. If tax is levied directly on personal or corporate income, then it is a direct tax. If tax is levied on the price of a good or service, then it is called an indirect tax. The purpose of taxation is to finance government expenditure. One of the most important uses of taxes is to finance public goods and services, such as street lighting and street cleaning. Since public goods and services do not allow a non-payer to be excluded, or allow exclusion by a consumer, there cannot be a market in the good or service, and so they need to be provided by the government or a quasi-government agency, which tend to finance themselves largely through taxes.

SERVICE TAX

Service Tax is a form of indirect tax imposed on specified services called "taxable services". Service tax cannot be levied on any service which is not included in the list of taxable services. Over the past few years, service tax been expanded to cover new services. The objective behind levying service tax is to reduce the degree of intensity of taxation on manufacturing and trade without forcing the government to compromise on the revenue needs. The intention of the government is to gradually increase the list of taxable services until most services fall within the scope of service tax. For the purpose of levying service tax, the value of any taxable service should be the gross amount charged by the service provider for the service rendered by him.

Aug 25, 2010 | Tally Computers & Internet

How to calculate taxable Income and how to calculate Income Tax for FY 10-11?

Hi, I researched this "website" for you,(http://multiutils.com/itax/itax0910.htm) hopefully it will have the answer your looking for, thanks. "Rating the help is appreciated, just click on the "Thumbs."

Apr 24, 2010 | Core Learning Calculation Skills: Volume 1...

What is vlookup & hlookup?

1024x768 Normal 0 false false false /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} These are Excel functions for Lookup tables. The purpose of Lookup tables is to bring a value to the table, find the closest (or exact) match, and then return another value.

An example is the federal income tax table. On your tax return you get your gross income and number of dependents, go to the Lookup table, and find your taxable income.

The V in VLOOKUP means that the table is vertical; HLOOKUP has a horizontal orientation.

If you use the Insert Function button in Excel and paste either function, the dialog box will explain each required field separately with examples.

Dec 02, 2008 | Microsoft Excel for PC

Computer Programming

HI
first of all dont expect experts to write you codes.
secondly,coming back to the problem this requires
nested if-else logic. with some logical operators involved.
(and - &&, pipe - ||).

I hope you have the logic and now you can easily write the code.

Aug 12, 2008 | Computers & Internet

Related Topics:

139 people viewed this question

Level 3 Expert

Level 3 Expert