Payroll Question

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

 

[Jean-Paul Viel]

Hi,



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

 

[Paul Corrado]

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

 

[dan]

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)

 

[dan]

That is a solution that I have never thought of, just be
careful because that will affect all spreadsheets.

Thanks
Dan