Excel 2010 Numerical Accuracy

BW999
BW999 used Ask the Experts™
on
I have a large Excel workbook with VBA macros.   I runs it in both Excel 2010 64 bit and Excel 2016 64 bit.  However, the output results are different.   Any thoughts?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Please describe the difference.
Ryan ChongSoftware Team Lead

Commented:
However, the output results are different.   Any thoughts?
could be formatting or data issues?

running both in same machine?

Author

Commented:
The discrepancy is in some of the numerical results written to worksheet cells.   There are no problems with the formatting and both the Excel 2010 and 2016 workbooks are running with the same input datafile contained in a separate workbook.
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Do you use very large or very small numbers? If so this article may help. Don't miss the section at the end that talks about correcting precision errors.

Another possibility is that If you have VBA code in the workbook and you use variables defined as Double or Variant (which is the default if you don't explicitly define the type) you may be able to change them to Currency if you don't need more than 4 decimal places.

Author

Commented:
Thanks
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial