Over two punishing days I had encountered a “Dirty Dozen” but was scrambling because of a deadline and…you know…assuming that fundamental features would/should always work. I must say that over the past 2-1/2 years of intense usage I have been mortified at the bugs within Excel I wish I had catalogued the list though did not, as each time I thought “Well, this must be a singular but noteworthy exception”. This was particularly egregious as it was a simple (A-B)/B calculation, and I watched it (over and over) calculating the wrong number as I stepped through the “Evaluate Formula” debugging tool while looking at my (annoyingly created) replicated test subset file and shaking my head in wonder and disgust. ** Yes, Excel can absolutely and overtly calculate incorrectly…and Joe’s solution of deleting and re-entering the formula fixed the issue for me. Though this thread is 4-1/2 years old, I have to thank Joe and this site as well as (re)alert others:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |