Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-04-2014, 08:42 AM
required_username required_username is offline Rounding values inconsistent Windows 8 Rounding values inconsistent Office 2010 32bit
Novice
Rounding values inconsistent
 
Join Date: May 2013
Posts: 28
required_username is on a distinguished road
Default Rounding values inconsistent

Hope this is easy.
I have a series of calculations and appear to be having trouble with rounding. I'll do my best to explain.

Cells C2 through C7 are multiplied by a different 'static' number and rounded to 2 decimal places. I then add C2 through C7 and put the sum in C9.
With frequency, the total showing in C9 is NOT equal to the values shown in C2 >C7. If the numbers don't match, the difference is always 0.01. I suspect this is due to the rounding. How do I get the value in C9 to give an accurate value? Or, is the C9 value correct but one of the values in C2>C7 wrong?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding values inconsistent Inconsistent Formatting YEG_V Word Tables 3 05-08-2013 03:06 PM
Custom formatting code - rounding problem venkys4u Excel 1 08-14-2012 07:45 PM
Rounding values inconsistent Standard Dev. Rounding - Excel judicial85 Excel 1 08-28-2011 05:41 PM
Inconsistent Margins judyfogarty Word 0 08-01-2010 02:54 AM
Rounding values inconsistent Federal financial rounding? markg2 Excel 6 05-26-2010 09:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft