IF for Federal Tax

Box 1: Does the employee made $20,000 per year

Box 2: Calculate how much the employee makes per year

Box 2 (continued): How much of that is over $20,000

Box 2 (continued): What is is Yearly Tax on that?

Box 2 (continued): How much is that for one week?

Box 2 (continued): Are parenthesis () needed to force subtractions to occur before multiplication? Please Excuse My Dear Aunt Sally

Box 3: What is his/her taxes if they make less than $20,000 per year?

[ Home ] [ Up ][ Payroll Spreadsheet Checklist ] [ IF for Federal Tax ][ Budget Spreadsheet ] [ Campus/Major Analysis ] [ Income Statement (P&L) ] [ Store Invoice ] [ Carpet Store Invoice ] [ Simplified Income Tax ] [ Car Loan Payback ] [ Payroll Sheet (Independent) ] [ Hints for Spreadsheets ] [ Vacation Time ] [Tutorials] [Spreadsheet Assignments] [All Assignments] [Site Search&Map]

This page was created by Professor Maureen Greenbaum and was last updated on 09/02/07 .

Page Name: IF for Federal Tax
URL: http://faculty.ucc.edu/business-greenbaum/Intro/C100SS_Payroll_IF.htm

Disclaimer: Information on this site represents the thoughts and opinions expressed by the author and not that of Union County College. The author takes full responsibility for the information presented. By using the information contained herein, the user willingly assumes all risks in connection with such use. Neither the author nor Union County College shall be held liable or responsible for content, errors, and/or omissions in information herein or information contained on any Web Page to which it is linked. Furthermore, neither the author nor Union County College shall be liable for any special, consequential, or exemplary damages resulting, in whole or in part, from any user's use of, or reliance on, this material or material set forth on any Web Page to which it is linked.
Copyright: ã Maureen Greenbaum Sumware in NJ 2001, '02, '03, '04, '05, '06, '07, 08, 2009. All rights reserved.