Just for the record, I AM THE KING OF EXCEL. Any doubts and I’ll Vlookup, Dsum, and toss in a Macro that’ll require the a long Counta to 10 before the ref says your done.
Gosh dang I’m a geek......
I work in extremely complex financial models all day and this “error check” in this article is weak at best. Plenty of ways to double check and validate formulas. A minor step up is using conditional formatting to highlight when numbers, using two different methods of calculation, don’t match.
That being said this was a major f**k up by these guys. This study was used by numerous people (including Paul Ryan) to push “austerity” as a way to avoid way below average growth. Turns out the “way below average” growth wasn’t so much. Not to say that 90+% debt/GDP is a good thing but it’s just not as bad as this study showed thanks to this basic Excel error.
OH KING OF EXCEL — How to create a cell with a flashing color background?
I can index, Imbedded If statement, & Sumproduct yah to death. Logical decisions via math!