|
|
|
| "be consistent" | |
| PerlMonks |
Re^3: Reading wrong value from excel sheetby space_monk (Chaplain) |
| on May 20, 2013 at 20:10 UTC ( [id://1034398]=note: print w/replies, xml ) | Need Help?? |
|
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)
If you spot any bugs in my solutions, it's because I've deliberately left them in as an exercise for the reader! :-)
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||||||||