Help Calculating Deductions In A Single Cell

pay of 5500, tax is applied to any income earned above $5000 tax -25%, $155 for health care, union fee 2% of salary, & 15% of salary for retirement fee, can one formula be derived to calculate all of that?

If you're trying to calculate net pay, where gross pay is $5500 (in cell A1), tax is 25% of anything over $5000, health care = $155, union fee is 2% of gross pay, and retirement fee is 15% of gross pay, then you want:

Please Login or Register  to view this content.

You can simplify this formula somewhat, but this version allows you to easily change any of the components.

ok thanks - i was using an if function - that made it all complex and % rather than the percent amt divided by 100 worked - thnks plenty