Remember Me?

#1
November 17th 06, 08:53 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 28
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
November 17th 06, 08:57 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 3,440
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
November 17th 06, 08:59 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 2,574
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Cantankerious Excel Discussion (Misc queries) 3 September 27th 06 07:42 PM Didier P Links and Linking in Excel 3 July 4th 06 04:39 PM roadsafetycouncil Excel Discussion (Misc queries) 1 June 7th 05 03:43 PM Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM

All times are GMT +1. The time now is 08:59 PM.