Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel bug?
I believe I have found an excel bug.
To replicate it put the following simple formulae in excel. In A1 put: 2.7 In A2 put: -4.3 In A3 put: 2.2 In A4 put: =5.2+(-5.8) In A6 put: =sum(A1:A4) If you make A6 show as many decimal places as possible you will suddenly discover a very small number is being produced. Oddly if you set A4 to contain -0.6 then it solves the problem. Any ideas what's going on? Alex. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |