[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On Tuesday 25 September 2007 10:06, Pete Hatton wrote: > Quoting Tom Potts <tompotts@xxxxxxxxxxxxxxxxxxxx>: > > I've read there are problems with excel 2007 > > Anyone have the misfortune to use it? > > =(8500 * 1) * 7.71 evaluates to 65535 > > > > =850*(771/10) evaluates to 100000 > > > > =850*(77.1) evaluates to 100000 > > I get 65535 for all 3 answers. Athough 100000 could be right if they > got some option on to round the number to the nearest 100000 > > Pete Hatton > --------------------------------- > E-mail: pete@xxxxxxxxxxxxx > Webpage: http://www.monolight.org > --------------------------------- http://www.theinquirer.net/gb/inquirer/news/2007/09/25/math-bug-found-excel its true - I can now use excel to calculate how much to sue them for! tom te tom te tom -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html