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....
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,