D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] excell 2006.9999

 

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
---------------------------------


-- 
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