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_tal
>k or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
------------------------------------------------------------------------------
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.
