Ok. Then, why -35.6 does not round up to -35 ? #Round(-35.6)# actually shows -36. That kinda confuses me.
Thanks, Pine Because it is closer to -36, it is the mirror image of +35.4 rounding to 35. The middle .5 is the special case that is always rounded up (ie in the positive direction). Rounding from -35.5 to -36 would be down (ie in the negative direction). It all goes back to that number line thing. -5 -4 -3 -2 -1 0 +1 +2 +3 +4 +5 Rounding of 1/2 will always be to the right, the positive direction. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA --------- | 1 | | --------- Binary Soduko | | | --------- "C code. C code run. Run code run. Please!" - Cynthia Dunning ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

