Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
adding actual numbers, not rounded
I'm making a payroll spreadsheet and taking the gross Wages times 6.2% and
gross wages times 1.45%. Then I want to take the gross wages and subtract the actual numbers shown in the columns from it to obtain net wages. How do I get excel to subtract only the actual numbers listed in the columns and not the invisible numbers with many decimal places. I am off a cent or two in my net wages figure. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
adding actual numbers, not rounded
You have a reply to your earlier posting.
Gord Dibben MS Excel MVP On Thu, 22 Oct 2009 15:04:01 -0700, geb wrote: I'm making a payroll spreadsheet and taking the gross Wages times 6.2% and gross wages times 1.45%. Then I want to take the gross wages and subtract the actual numbers shown in the columns from it to obtain net wages. How do I get excel to subtract only the actual numbers listed in the columns and not the invisible numbers with many decimal places. I am off a cent or two in my net wages figure. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ROUNDED NUMBERS | Excel Worksheet Functions | |||
Footing rounded numbers | Excel Worksheet Functions | |||
numbers being rounded | New Users to Excel | |||
how do i add rounded numbers? | Excel Discussion (Misc queries) | |||
ROUNDED NUMBERS IN FORMULA'S | Excel Discussion (Misc queries) |