Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 06-04-2014, 07:13 PM
BobBridges's Avatar
BobBridges BobBridges is offline Rounding values inconsistent Windows 7 64bit Rounding values inconsistent Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Quote:
Originally Posted by required_username View Post
In my case, the values are $0.00 so exact is a necessity. I'll try "ROUND" and see if it solves my problem. I would expect I can avoid teh middle man and have the value in C2 calculated as =ROUND(R7*J2+J5,2). Correct?
Sure, you can. All it cares is that it has some kind of numeric value to work with. Sometimes in my anxiety to boil things down to as few steps as possible I combine so many things into one that it gets much harder to understand; in such a case if I overdo it, it's sometimes better to break it up into pieces. But you're not near that threshold here..
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 05:23 AM.


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