row of $ numbers don't crossfoot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

a list of employee pay is being multiplied by the medicaid, ss and disability
rates to end with a net pay assuming no fed or state withholding. the
formula for the net is the gross less the three calculated tax results. the
result net pay is off by a penny in several cases probably due to rounding in
the formula but i can't figure out how to resolve.
 
In Superman 3, Richard Pryor resolved this by pocketing the difference and
becoming an evil genius... but that did not work out well in the end.

I would use the Round() function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locking cell data from change 1
Pivot Tables? 5
Functions for weekly net pay, single, 1 witholding, no state tax? 2
Payroll - net to gross? 3
Federal tax withholding calculations - using IF statements..? 12
excel question 7
Circular Reference Problem Calculating Net Pay 6
Rounding Net Pay Circular Reference Problem 2

Back
Top