According to Excel 2007, any equation that should result in 65,535 Excel 2007 will tell you that the answer is 100,000.

I actually prefer 100,000 to 65,535, its an even number, it is easily divisible by 10, its a lot larger then 65,535. But, when I’m building complicated spreadsheets (which I don’t do) I think I would rather have the application compute my equations correctly.

Microsoft is working on a fix to the bug but until then why not build some spreadsheets with equations such as:

  • 5.1*12850
  • 10.2*6425
  • 20.4*3212.5
  • 40.8*1606.25
  • 77.1*850
  • 154.2*425
  • 212.5*308.4

[via AppScout]