|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 22nd, 2009, 11:04 PM
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
October 23rd, 2009, 12:14 AM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
