Comes up with correct 65535 in Office 2002, have just started upgrading to 2007 at the office here and confirmed that it does come out wrong in 2007, wonder if it is part of the new XML switch.. they need to fix that soon for sure.. file saved in 2002 when opened in 2007 will change the result of the formula as well..
Wow. Wonder how many other bugs are in there? As to the fix, who knows. The programmer probably doesn’t speak English.