CELL j = CELL j-1 + 0.1 => demostrated This NOT WORK

[gvicenci]

Excel_error2.xls
	A	B	C	D	E
2		GermanVicencio		X	Integer(X)
3				0,00000000000000	0
4		Incredible....ButTRUE!		0,10000000000000	0
5		MSEXCELdoesNOTSUMcorrectly.		0,20000000000000	0
6		Ifyoucreateasimpleformulaliketheone		0,30000000000000	0
7		incolumn"D"(CELLj=CELLj-1+0.1)		0,40000000000000	0
8		Youwillrealizethatexcellosecontrolafter		0,50000000000000	0
9		repeating/filldowntheformula		0,60000000000000	0
10		andgenerateWRONGresults!!		0,70000000000000	0
11				0,80000000000000	0
12		Accordingtothis:6=5??!!!!		0,90000000000000	0
13				1,00000000000000	1
14		Unfortunatellyduetothelimitationsinsize		1,10000000000000	1
15		forpostingontheboardIcan'tshowexplicit		1,20000000000000	1
16		theevidence.However,ifyoufilldown		1,30000000000000	1
17		theformulain"D"and"E"youwillhavethe		1,40000000000000	1
18		evidenceofthisbig!Error!		1,50000000000000	1
19		AfterRow62theworksheetget"crazy"		1,60000000000000	1
20		SorryBillGates.......Butyourprogrammer		1,70000000000000	1
21		didabasic"math"errorhere!!		1,80000000000000	1
22				1,90000000000000	1
23				2,00000000000000	2
24				2,10000000000000	2
25				2,20000000000000	2
26				2,30000000000000	2
27				2,40000000000000	2
28				2,50000000000000	2
29				2,60000000000000	2
Hoja1

 

[Juan Pablo González]

Re: CELL j = CELL j-1 + 0.1 => demostrated This NOT

Try OpenOffice (And even better, you could modify the code yourself to suit your exact needs...)

 

[kskinne]

Re: CELL j = CELL j-1 + 0.1 => demostrated This NOT

my 2¢:

i agree with Juan - if you feel Microsoft has written a substandard program, then write your own spreadsheet program that calculates with the precision you desire, and when it's completed, update us here on the board. no offense intended to you or anyone else for that matter, but this discussion is getting old

 

[PaddyD]

Re: CELL j = CELL j-1 + 0.1 => demostrated This NOT

"...is getting old"

wrong tense

 

[kskinne]

Re: CELL j = CELL j-1 + 0.1 => demostrated This NOT

sorry i wasn't being very precise

sorry couldn't resist

 

[Legacy 12630]

To GV

You wrote "That kind of statement does not add any value to the analysis"

You are, of course, entitled to you opinion on whether or not my statement adds any value to this thread.

Some people might question whether this whole thread has any value whatsoever.

Your posts tend to indicate that you are not entirely happy (am I right?) about the minor variances that can occur in Excel with floating point arithmetic after 15 decimal places (or something like that).

Why is this matter so important to you?
(It must be important since you've almost posted enough words to publish a book.)

With regard to the posters who have hinted that this thread has become "old hat", just ignore them - they are impolite.
I think we are just getting started on this topic, and in the right direction.

 

[tusharm]

Re: CELL j = CELL j-1 + 0.1 => demostrated This NOT

Did you do the 1/3 test I suggested? What was the result?

Did you check the MSKB article I pointed out? Did you provide MS with feedback on it?

If not, why are you babbling on and on and on and on and on and on...
on this subject on this web site? To the best of my knowledge, it is neither owned, managed, or monitored by MS.

If you are so sure this is a bug, why don't you do something useful? File a report with MS? Start with http://support.microsoft.com/default.aspx?scid=fh;[ln];msservices

There is a bug….. and I believe MS will correct this BUG in the near futur.
I’m just presenting the fact/bug.

by MS, particulary in excel is not full perfect. Why ?
Therefore, there is a bug in excel.
So, Conclusion, what is the BUG (again) ….……. :

MS have a bug ( in excel ) since the
Note : MS recognize that they don’t adhere to ALL the “IEEE 754” specification.

( however, they fail in this part of the implementation and this is the BUG )

 

[tusharm]

LOL!

I think we are just getting started on this topic, and in the right direction.

 

[SydneyGeek]

Re: CELL j = CELL j-1 + 0.1 => demostrated This NOT

I agree with Paddy and Tushar.

Quick comment:
In VBA you can set the numerical data type. On a worksheet you always have Double (binary, 15 decimal places). HOwever, VBA gives the options of Currency (a scaled DECIMAL that doesn't have these issues -- obviously the one to use for financial calcs); and you can also convert a Variant to a Decimal and avoid the issue that way.

Still not much help if you do most of your work on a worksheet, but there are ways to guarantee absolute accuracy if you must have it.

 

[Legacy 12630]

LOL!

I think we are just getting started on this topic, and in the right direction.

I'm sure GV has a lot more to write on this subject, and I am really looking forward to it, even if you aren't.

I think it is unfair of you to try and cut him short just when he's really only just started.

I don't think it will take a lot of effort to keep this thread going for a long time - possibly years.

 

[just_jon]

Re: CELL j = CELL j-1 + 0.1 => demostrated This NOT

I've read the whole thread, and have a few thoughts. Keep in mind this is a help forum; as I see it, the OP A] knows there is an issue/bug with XL regards precision, and B] is not in search of a solution, and C] does not have a solution of his own to offer. Other than to alert us to what we already know, I see no point to this thread being here -- should be in Max Cells, as the OP is wanting to engage in a discussion rather than a solution.[/b]