Episode #1827A: Back to the Microsoft Ad: can you select a cell and not have the value appear in the formula bar? Yes. Also, a Microsoft PR guy claims the ad is *correct*, that they have not yet pressed Enter, hence the total hasn’t updated. But you will see, frame-by-frame, that the chart updates as quickly as the AutoSum. Bottom line: It is a bad formula. Or Photoshop. Never do math with Photoshop!
Links in the Sources and Video:
- David Yanofsky “Botched Excel Spreadsheet in Surface Ad“
- Brad Sams “Web Excel File“
- Alex Wilhelm at TechCrunch “Microsoft Didn’t Get Its Math Wrong“
- David Shaw Twitter Conversation “AutoSum Recalculates After Editing“
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
Visit us: MrExcel.com for all of your Microsoft Excel Needs!