Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-14-2019, 05:53 AM
Marcia's Avatar
Marcia Marcia is offline excel macro returning the wrong value Windows 7 32bit excel macro returning the wrong value Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by Pecoflyer View Post
Thank you for this Pecoflyer. In the 2017 annual financial report that I prepared for our agency, the person in charge of consolidating all reports accused me of "force balancing" the accounts because when she manually entered all the data there was a .01 difference. I used the ROUND function in calculating the depreciation expenses but there's still the .01 problem. I will try the the Precision as Displayed option come year -end.
Reply With Quote
 

Tags
cell value, excel macro

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel macro returning the wrong value Table column width wrong - unless macro paused!? Kebap Word VBA 7 09-21-2018 03:14 PM
Returning text, date, time, location from one Excel sheet to another dave57 Excel 17 06-15-2017 10:45 AM
excel macro returning the wrong value Excel colums are wrong way around SteveL Excel 1 05-06-2015 02:09 AM
excel macro returning the wrong value Macro operates on wrong document window marceepoo Word VBA 1 12-20-2012 03:12 PM
need macro for quiz (?) repeat of wrong answers with shuffle braveshark PowerPoint 0 10-02-2012 06:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:22 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