Re: =850*77.1 = 65535
- From: Stan Brown <the_stan_brown@xxxxxxxxxxx>
- Date: Fri, 12 Oct 2007 17:22:45 -0400
Fri, 12 Oct 2007 13:43:43 +0300 from Opinicus <gezgin@xxxxxxxxxxx>:
"Harald Staff" <stf@xxxxxxxxxxxxx> wrote
What's the problem? The statement is true:
65535/850 = 13107/170 = 3*17*257/17*2*5 = 771/10 = 77.1
The problem is a well known bug in Excel 2007, the calculation in mention
displays 100 000. The link is to fix it.
Ah so. I'm still using Office XP and Excel 2002, which apparently doesn't
suffer from the bug.
It was introduced in Excel 2007. This has been discussed pretty
extensively.
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/
.
- References:
- =850*77.1 = 65535
- From: Tyro
- Re: =850*77.1 = 65535
- From: Opinicus
- Re: =850*77.1 = 65535
- From: Harald Staff
- Re: =850*77.1 = 65535
- From: Opinicus
- =850*77.1 = 65535
- Prev by Date: Re: Vlookup
- Next by Date: Re: select last column and last nonblank cell
- Previous by thread: Re: =850*77.1 = 65535
- Next by thread: RE: =850*77.1 = 65535
- Index(es):
Relevant Pages
|
