Office & Productivity Software forum

General discussion

Creating Tax Chart

by andoyan / August 22, 2006 3:45 PM PDT

Hello All
I use excel to do payroll and it works great to calculate the deductibles with exception of tax (Federal or State Tax), For that I use the tax chart and enter it manually. Is there a formula that I can use to have that done without using the tax cart book!!!?
Example of the function that I like to see Is:
If the amount is between 100. to 150.00 there is a 50.00 tax deducted, now when the I raise the amount of the salary to 160 the tax also gets raised to 52.00.
The actual tax chart has all the numbers from .01 to 10.000 and also it has coordinated the amount of tax based on that. So I can use the numbers from tax chart to establish a correct numbers.
I hope I was able to explain This correctly
Any Help Would be greatly appreciated,

Discussion is locked
You are posting a reply to: Creating Tax Chart
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Creating Tax Chart
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
Tax deduction at payroll..
by Papa Echo / August 22, 2006 6:24 PM PDT
In reply to: Creating Tax Chart

You may have to create a tedious formula consisting of a combination of logical functions, financial functins, etc... or a equally tedious VBA script (lots of IF THEN statements ?). Why not a payroll program, e.g. HERE ?

such are also found in acounting softwares, maybe also included in Microsoft 2003 small Office Edition....

Collapse -
A two step process.
by Kees Bakker / August 22, 2006 6:43 PM PDT
In reply to: Creating Tax Chart

One: find the formula
Two: find the best way to program it in Excel

A custom VBA-function seems the best way to do this. It surely depends on the formula how many lines (anywhere from 5 to 30, I'd say) it is.


Collapse -
Excel answer
by jhancock284 / August 24, 2006 4:42 AM PDT
In reply to: Creating Tax Chart

Try creating a table in Excel and then using VLOOKUP.

Popular Forums
Computer Newbies 10,686 discussions
Computer Help 54,365 discussions
Laptops 21,181 discussions
Networking & Wireless 16,313 discussions
Phones 17,137 discussions
Security 31,287 discussions
TVs & Home Theaters 22,101 discussions
Windows 7 8,164 discussions
Windows 10 2,657 discussions

Does BMW or Volvo do it best?

Pint-size luxury and funky style

Shopping for a new car this weekend? See how the BMW X2 stacks up against the Volvo XC40 in our side-by-side comparison.