Thread: Function Int
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bcar bcar is offline
external usenet poster
 
Posts: 2
Default Function Int

Hi all,

I'm surprise by this result on excel( 2000, 2002, XP ) (win200, XP)

sub test()
Dim x as Long

x = Int(37.7266 * 10000)
' x = 377265
' I hope x = 377266

' but for :
x = int(37.7263 * 10000)
' I have x = 377263
end sub

In fact 37.7263 give expected result, 37.7264, no, 37.7265,
ok and so on...
Does somebody have an explanation ?