Payroll Question

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

I am trying to set up my old office's payroll on a
spreadsheet so that the new secretary doesn't have to
spend so much time on payroll each week. The problem I
am having is when calculating the SSI & Med, Excel
automatically rounds the answer to two (2) decimals, but
when I total the column it adds using the the extended
figure (ex.: $323.00 * .062 = $20.026, in my column it
will round the answer to $20.03, but when I total the
column to show an employee the withholdings for the year,
excel totals the column using the $20.026 amount. I need
to have the total calculated using the two decimal dollar
amount. Cany anyone help? Thank you.
 
Hi,



In Tool>Option and then on the tab Calculation, put a check mark for
"Precision as display".
 
Robin,

While XL is displaying the SSI with two decimal places it is probably not
rounded. The best thing to do here is probably to use a ROUND formula to
calculate the withholdings. That will then flow through to the SUM and your
figures will tie.

ROUND(Pay*SSI rate,2)

PC
 
You can round a value by typing the following formula...

=round(d1,2)

The first part is the cell you want rounded, the second is
the number of decimal points you would like to use
(negative numbers round in tens)
 
That is a solution that I have never thought of, just be
careful because that will affect all spreadsheets.

Thanks
Dan
 
Back
Top