Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions for weekly net pay, single, 1 witholding, no state tax?
I know that my witholding allowance is: $291.67
Income tax withholding is: $302.95 plus 28% SS Tax percent w/held: 6.2% Medicare Tax w/held: 1.45%. I do not pay State Taxes, and have no additional witholdings. I've built my spreadsheet to calculate my pay-per-period, and can get to the Gross Pay total, but am not Excel friendly enough to figure out how to use functions to calculate the above withholdings in order to determine my take-home pay. I've used the online paycheck calculators, which are accurate, but they don't tell me what formulas/functions were used. Help please! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
with weekly score sheet how do I column a weekly progressive aver. | Excel Worksheet Functions | |||
formula on Witholding tax computation | Excel Discussion (Misc queries) | |||
city, state, zip from a single cell to multiple cells | Excel Discussion (Misc queries) |