Re: Reading wrong value from excel sheet

[space_monk]

Looks like a rounding error - can't you format the results to show values in the needed precision?

[sandeep_car]

Hi space_monk,

Thnks for your repply. This happens only with some record like in 1,000 records only with 5-6 record. So can't format it or do round off again as this will affect other value.I dont want other value to be rounded off. There are values which have values upto 3 places or 4 places.

thanks,

Sandeep

[space_monk]

Your calculations will still round up if you accept 5 or 6 decimal places, From your examples It is only the least significant bit at 14-15dp or so that is causing the problem

1.139999999999999 will round up to 1.14 at anything up to 14dp (if I've counted correctly)