Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
![]()
Please do not separately post the same question to different newsgroups.
Oh, sorry for this. Never more I will do it. As respondants in both threads have pointed out, this is a well known property of finite precision arithmetic exacerbated by binary representation of numbes. It is not a bug and is not unique to Excel. Well, it's not a bug, but a "feature". Where in the hell is this "feature" explicited at help system ? Not so easy to find... And of course, for a common user, a number is a number, and nothing more. If it's typed at 2 decimal precision, it could be good that sum and multiplycation of it could be also at those 2 single decimal precision. No use of thinking about IEEE, 15 limit precision, binary internal representation, and so on... Unless the user ask for it. I tried the solutions and as trunc() worked well, I put it everywhere. Now the calculations take some time (few miliseconds more). Also the parens () works well, but I can not trust 100%. Well, thanks anyway. yours, Daniel from Brazil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |