 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Rounding Problem
I have got a very simple accounting spreadsheet where column C is determined by (A+B)*1.06. Cell C is formatted for dollars - two decimal places. At the bottom of column C is a total which is usually correct but sometimes it is out by one cent. All the calculations across are correct. I am sure there is an easy way to fix this isn't there? Thanks. Al Check this link of John McGimpsey: http://www.mcgimpsey.com/excel/pennyoff.html  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > I have got a very simple accounting spreadsheet where column C is > determined by (A+B)*1.06. Cell C is formatted for dollars - two [quoted text clipped - 4 lines] > > Al See http://www.mcgimpsey.com/excel/pennyoff.html > I have got a very simple accounting spreadsheet where column C is > determined by (A+B)*1.06. Cell C is formatted for dollars - two [quoted text clipped - 4 lines] > > Al did you try =Round((A+B)*1.06,2) will there be no problem in your accounting sheet if you do so? > I have got a very simple accounting spreadsheet where column C is > determined by (A+B)*1.06. Cell C is formatted for dollars - two [quoted text clipped - 4 lines] > > Al Thanks everyone, that Round function should solve the problem. I also discovered in the Excel Options how to set the precision to what is displayed. Just have to ignore that terrible warning that my spreadsheet will lose accuracy. Al I use Excel so often that every time I do Micsoft has a new version ;-( >did you try > [quoted text clipped - 10 lines] >> >> Al glad it worked for your accounting sheet!<g> > Thanks everyone, that Round function should solve the problem. I also > discovered in the Excel Options how to set the precision to what is [quoted text clipped - 20 lines] > >> > >> Al I would suggest that you NOT use the "Precision as displayed" setting. It can cause rather odd results in calculations if various cells have a different number of decimal places. You should use ROUND instead. See http://www.cpearson.com/newsletter/content/2007_08_27.htm This article illustrates a rather simple case in which you can have three different values when summing the same numbers. SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) > Thanks everyone, that Round function should solve the problem. I also > discovered in the Excel Options how to set the precision to what is [quoted text clipped - 19 lines] >>> >>> Al Look at: http://www.cpearson.com/excel/rounding.htm SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >I have got a very simple accounting spreadsheet where column C is > determined by (A+B)*1.06. Cell C is formatted for dollars - two [quoted text clipped - 4 lines] > > Al you can also try to upgrade your reading within this page. http://www.microsoft.com/office/community/en-us/default.mspx?query=%22test%2C+de c+As+Long%2C+ParamArray+rng%22&dg=microsoft.public.excel.programming&cat=en-us-e xcel&lang=en&cr=US&pt=f3f7ac8a-4ea0-4c36-bed9-8feae6d75298&catlist=&dglist=&ptli st=&exp=&sloc=en-us > I have got a very simple accounting spreadsheet where column C is > determined by (A+B)*1.06. Cell C is formatted for dollars - two [quoted text clipped - 4 lines] > > Al
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.