| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding actual numbers in columns
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding actual numbers in columns
You have to use rounding:
=ROUND(GW*6.2%,2) =ROUND(GW*1.45%,2) -- Biff Microsoft Excel MVP "geb" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding actual numbers in columns
Thank you very much!!
"T. Valko" wrote: You have to use rounding: =ROUND(GW*6.2%,2) =ROUND(GW*1.45%,2) -- Biff Microsoft Excel MVP "geb" wrote in message ... 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. . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding actual numbers in columns
You're welcome!
-- Biff Microsoft Excel MVP "geb" wrote in message ... Thank you very much!! "T. Valko" wrote: You have to use rounding: =ROUND(GW*6.2%,2) =ROUND(GW*1.45%,2) -- Biff Microsoft Excel MVP "geb" wrote in message ... 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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding actual numbers, not rounded | New Users to Excel | |||
| adding zeros to numbers in columns | Excel Discussion (Misc queries) | |||
| Adding and subtracting many columns numbers | Excel Worksheet Functions | |||
| ADDING NUMBERS IN COLUMNS ACROSS IN EXCEL | Excel Worksheet Functions | |||
| problem with adding columns of numbers | Excel Worksheet Functions | |||
Linear Mode
