>From the CF Docs - seems they work the way they are supposed to. Have always thought of Ceiling and Fix as being opposites, but actually Ceiling and Int are. Ceiling - Returns the closest integer greater than a given number. Fix - Returns the closest integer less than number if number is greater than or equal to 0. Returns the closest integer greater than number if number is less than 0. Int - Returns the closest integer smaller than a number. (-5 is smaller than -4) Round - Rounds a number to the closest integer. (-4.4 is closer to -4 than -5) Dan -----Original Message----- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 26, 2000 8:16 AM To: [EMAIL PROTECTED] Subject: RE: Surprising Results? [was] Re: Round down numbers Yeah, I guess the rounding is correct: I tried the tests in Excel & got the same Results: =ROUND(4.599,2)+ROUND(-4.599,2) gives 0 But the int, I don't understand: =INT(4.599)+INT(-4.599) gives -1 Wonder why? At 3:43 PM +0100 7/26/00, Stephen Moretti wrote: >Dick, > > >[snip] >> <BR>.*.Round(-4.5).....Gives -5....Expect -4.....|#Round(-4.5)#| >> <BR>.*.Round(-4.4).....Gives -4....Expect -5.....|#Round(-4.4)#| >[snip] >> <BR>.*.Int(-4.5).......Gives -5....Expect -4.....|#int(-4.5)#| >> <BR>.*.Int(-4.4).......Gives -5....Expect -4.....|#int(-4.4)#| >[snip] >> .*.Round(-4.5).....Gives -5....Expect -4.....|-5| >> .*.Round(-4.4).....Gives -4....Expect -5.....|-4| >[snip] >> .*.Int(-4.5).......Gives -5....Expect -4.....|-5| >> .*.Int(-4.4).......Gives -5....Expect -4.....|-5| > >The rounding one is actually correct, -4.5 should round to -5. >However the int on -4.4 and -4.5 are a bit strange. I can't think why this >would be, but I feel like there should be a reason. > >regards > >Stephen > ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
