| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
federal tax tables
This may be useful:
http://www.mcgimpsey.com/excel/variablerate.html In article , Bob wrote: I can't seem to get the formula right on this. Here is the example: I have a field for gross wage and a field for federal tax. The year to date field increases with each pay period. The YTD spans 2 tax brackets i.e.; <$15,100 is taxed at 10%, $15,100 at 15%. I have been trying to work with the "if" function. Everything is fine until I hit the threshold then all previous numbers reset to the higher rate. I'd like to be able to use this as a template so I really don't want to lock the value in each cell. Should I be approaching this with a different function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Three tables on one worksheet, need to hide rows | Excel Discussion (Misc queries) | |||
| Match two tables using unique ID number | Excel Discussion (Misc queries) | |||
| How to pull numbers from two tables with conditions? | Excel Worksheet Functions | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
| How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) | |||
Hybrid Mode
