PDA

View Full Version : Microsoft spreadsheet formula


binx44
Apr 27, 2011, 09:40 AM
I live in nova scotia canada, I was wondering what I would use as a formula to determine my paycheck after taxes. I have my money earned before taxes already calculated using proper spreadsheet formulas.

This is not a homework thing lol, I've been out of school for years. This is me trying to figure out if I'll have enough money for rent out of my pay from my new job

JBeaucaire
Apr 28, 2011, 07:04 PM
A spreadsheet can be used to automate any math problem you can visualize. If you know your tax rates and your paycheck amount, it's a simple formula.

A1 = your tax rate... like 15%
A2 = your gross pay

A3: =A2*(1-A1)

ScottGem
Apr 29, 2011, 03:54 AM
The problem here is not all deductions use the same formula.

Are you an hourly employee so your paycheck varies? You can probably get the percentages from your payroll department.