Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 17th 06, 09:53 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 28
Default 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   Report Post  
Old November 17th 06, 09:57 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default 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   Report Post  
Old November 17th 06, 09:59 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 2,574
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting ASCII Into Excel, any Ideas? Cantankerious Excel Discussion (Misc queries) 3 September 27th 06 07:42 PM
Excel file with hyperlinks takes a long time to open over the network Didier P Links and Linking in Excel 3 July 4th 06 04:39 PM
Formula to select top 3 from 4 totals in excel roadsafetycouncil Excel Discussion (Misc queries) 1 June 7th 05 03:43 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 12:32 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM


All times are GMT +1. The time now is 09:22 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017