Payroll - drop partial pennies

  • Thread starter Thread starter Ted Dawson
  • Start date Start date
T

Ted Dawson

I'm trying to do payroll.. one of the cells calculates the Medicare amount
(=J3*0.0145) and correctly displays the amount (for example: $16.54). But
when I sum the column, excel adds all the digits that are greater than the
two digits, and therefore adds a penny or two to the total. How do I get
excel to NOT add the amounts greater than 2 digits to the right of the
decimal?
 
Change your first formula to:

=ROUNDDOWN(J3*0.0145,2)

and then copy this down as appropriate.

Hope this helps.

Pete
 
Back
Top