adding actual numbers in columns

[geb]

I am making a payroll spreadsheet. Gross wages times 6.2% and Gross Wage
*1.45%, then want to take G wage and subtract the numbers from the calculated
columns to arrive at net wages. How can I add the actual numbers appearing
in the display and not the invisible numbers with lots of decimal places.
I am off a cent or two in the Net wages column.

 

[T. Valko]

You have to use rounding:

=ROUND(GW*6.2%,2)
=ROUND(GW*1.45%,2)

 

[geb]

Thank you very much!!

You have to use rounding:

=ROUND(GW*6.2%,2)
=ROUND(GW*1.45%,2)

--
Biff
Microsoft Excel MVP





.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you very much!!