View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default RoundDown function not working in code


"Don G" wrote in message
...
On Aug 15, 12:14 pm, "Harald Staff" wrote:
-0.775 to -0-780 is down, isn't it?

Best wishes Harald


No it isn't Harald, down is towards zero. But anyhow my concern is
why the same function on the same numbers give different results.
Thanks for thinking about it.

Sorry it was posted unintended.
The result of a calculation may be slightly off an exact decimal, like
0.774999989, so they're not necessaqrily the same numbers even if they
display the same.

Best wishes Harald