Calculation Issue Update

re: Calculation Issue Update

John — Wed, 24 Oct 2007 22:42:59 GMT

Shame on you, Microsoft! Don't think it was programmers' fault: bloatware life cycle is so difficult to tackle.

re: Calculation Issue Update

ScottB — Tue, 23 Oct 2007 23:17:31 GMT

@Daniel Tackley: it's likely bankers' rounding (round-to-even). See en.wikipedia.org/.../Banker%27s_rounding.

re: Calculation Issue Update

SeanC — Mon, 22 Oct 2007 15:11:50 GMT

Daniel, the first Round you use is a worksheet function. To reproduce this in VB try

Application.WorksheetFunction.Round(1408.7705, 3)

Why the second one rounds down for 5 I couldn't tell you, at school it was round up for 5 and above!

re: Calculation Issue Update

Daniel Tackley — Mon, 22 Oct 2007 13:56:32 GMT

Has anyone seen this before...

If working on an Excel worksheet, Round(1408.7705,3) gives the expected result of 1408.771

If I do the same in VB, I get 1408.770

Any ideas why the VB example is rounding down not up?

re: Calculation Issue Update

AdamV — Sat, 20 Oct 2007 11:29:31 GMT

@Thaddeus

The Dec2Hex non-bug has been widely misreported.

I have replied more fully to the comment on the same subject that you left on my blog here:

veroblog.wordpress.com/.../excel-2007-calculation-bug-fix-released-after-two-weeks

re: Calculation Issue Update

Andreas Eckert — Thu, 18 Oct 2007 09:49:07 GMT

I have another oddity of wrong calculations. I am using Excel 2003.

If you SUM up the following numbers, EXCEL will show 98703.22. If you do a comparison with the absolute value of 98703.22 and the SUM calculation, is shows there is a difference of ~ 0.00000000035

Hence the formular =IF(98703.22<>SUM(B2:B275),"X"," ") with the range B2 to B275 containing the following values, will show an X:

349.58

2,796.64

349.58

428.12

349.58

428.12

349.58

Corrupt Excel Repair

webmaster6@nucleusdatarecovery.com — Thu, 18 Oct 2007 08:07:18 GMT

I am using old version. I did not know the calculation problem with excel 2007. Such a great explanation.

Thank you

Damon Thomas

www.excelfilerecovery.com

http://www.excelfilerepair.com

re: Calculation Issue Update

Thaddeus — Thu, 18 Oct 2007 06:14:34 GMT

I just loaded the hot fix, I think there is still an error.

Prior listings warned aboout =dec2hex(850*77.1)returning fffe, when it should return ffff.

The hot fixed excel returns fffe for the calculated value of (850*77.1).

Do the following:

a1 =850*77.1 (65535)

b1 =dec2hex(a1) (fffe)

c1 =hex2dec(b1) (65534)

d1 =sqrt(850*77.1)^2 (65535)

e1 =dec2hex(d1) (ffff)

now I can see b1 is not equal to e1

re: Calculation Issue Update

masterz3d — Tue, 16 Oct 2007 19:21:10 GMT

...I'm not referring to Excel as Excel, but as a calculation program. If such program gives uncorrect results, that's not a good program, and it should be corrected as soon as possible. Or recalled.

Microsoft should have done a better beta-testing and bugfixing before releasing it to the market.

End of story.

I HOPE there will be more serious beta-testing from now on.

inefficiency of excel 2007

ashok abnave — Sat, 13 Oct 2007 20:39:14 GMT

my worksheet contains 5 columns for stock market : ,, , and

QUERY: if is greater than and , then must be "strong" or if is less than and ,then must be poor.

I tried three different formulas below for this query ,but they doesn't work:

A2=

B2=

C2=

D2=

E2=

formula for E2

=OR(IF(AND(A2D2,B2>D2),"Poor",FALSE))

////////////////////////////////

=OR(IF(AND(A2D2,B2>D2),"Poor",""))

////////////////////////////////

=OR(IF(AND(A2D2,B2>D2),"Poor"))

I find it difficult to formulate the above condition with available functions in excel 2007. Please mail me solution or formula at my e-mail 'ashokabnave@yahoo.co.in'