Payroll - drop partial pennies

[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?

 

[Pete_UK]

Change your first formula to:

=ROUNDDOWN(J3*0.0145,2)

and then copy this down as appropriate.

Hope this helps.

Pete

 

[Shane Devenshire]

Hi,

The standard method

=ROUND(J3*0.0145,2)

 

[Ted Dawson]

=ROUND(J3*0.0145,2)


This is the answer. Thank you!