View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Simple INT error?

On Fri, 03 Oct 2003 09:05:09 -0600, "J.E. McGimpsey"
wrote:

I've never encountered that before. In XLv.X:

? int( 0.6 * 100)
60


That's odd.

Excel 2002(10.4524.4219) SP-2
in a worksheet =INT(0.6*100) -- 60

But in the VB6.3 that comes with it, I get 59 in the Immediate window, too.
?int(0.6*100)
59

XP Pro
Processor x86 Family 15 Model 2 Stepping 4 GenuineIntel ~1993 Mhz





--ron