a Sift Media publication
Over 23,000 pages of accounting passion and insight!   |   Sift Media logo
AccountingWEB US blogs

Precision As Displayed "Flaw"

Back to blog homepage for: Accounting Technology Talk and More

So why do we get the very poorly worded warning and why has this simple problem not been fixed? Is it a difficult programming issue or has it just not received adequate attention. Not needing =round() and not suffering
from unnoticed rounding errors in reports is after all a huge issue in the minds of the vast majority of users (casual empiricism after providing training to 100000s of business professionals).

Even if this is a programming nightmare, the warning could at least be revised to be useful. After all, the only assumptions that are negatively impacted are digits entered without the benefit of being proceed by the =
sign. Is there any other issue. I don't believe so. Formula are never adversely impacted (if you don't believe this then provide an example). VBA people are welcome to comment (I hope that is an acceptable way to address this audience).

Even more importantly, the feature is never promoted by Microsoft and virtually unknown to the vast majority of users who simply see calculations that use un-displayed precision as errors that must be corrected by using the
=round() function. (If someone would just tell them that there it is toggle switch that as been in the product for 20 years.)

_______
Will Fleenor, Ph.D, CPA, is CFO of K2 Enterprises, LLC, and makes his home outside Hammond, Louisiana.



Welcome Visitor!
Sign up for the Weekly Insight newsletter to stay informed of future content in this category.
Email:
Already have an account? Sign in:
Forgotten your password?
Join us FB Connect with us LI Follow us
Voice of the Editor
Amidst a certain amount of controversy, the AICPA and the Chartered Institute of Management Accountants have launched a new designation for global management accountants, the CGMA (Chartered Global Management Accountant). The designation is available to members of both organizations.
Read more >>

Gail Perry, CPA
Editor-in-Chief, AccountingWEB
editor@accountingweb.com