Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My Excel totals are always 1 or 2 cents too low. Any ideas?
Using Excel 2003, front worksheet has a column with a total at the bottom.
Cells that are being added in that column are derived from other worksheets within the same workbook. My total at the bottom of the column is always 1 or 2 cents too low. I'm suspecting the figures were rounded up somewhere alon the line and now the final figure is not rounding up. Any help would be greatly appreciated. Andyb |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
My Excel totals are always 1 or 2 cents too low. Any ideas?
http://www.mcgimpsey.com/excel/pennyoff.html
-- Kind regards, Niek Otten Microsoft MVP - Excel "Andyb" wrote in message ... | Using Excel 2003, front worksheet has a column with a total at the bottom. | Cells that are being added in that column are derived from other worksheets | within the same workbook. My total at the bottom of the column is always 1 | or 2 cents too low. I'm suspecting the figures were rounded up somewhere | alon the line and now the final figure is not rounding up. Any help would be | greatly appreciated. | | Andyb |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
My Excel totals are always 1 or 2 cents too low. Any ideas?
=ROUND(A1,0) will round the value in A1 to the nearest whole number.
Dave -- Brevity is the soul of wit. "Andyb" wrote: Using Excel 2003, front worksheet has a column with a total at the bottom. Cells that are being added in that column are derived from other worksheets within the same workbook. My total at the bottom of the column is always 1 or 2 cents too low. I'm suspecting the figures were rounded up somewhere alon the line and now the final figure is not rounding up. Any help would be greatly appreciated. Andyb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Converting ASCII Into Excel, any Ideas? | Excel Discussion (Misc queries) | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Formula to select top 3 from 4 totals in excel | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |