-
Rounding to the nearest even number
I'm looking for a rouding routine
For integers ending in ?5? round to the nearest even number.
e.g. 3.465 rounds to 3.46
3.455 rounds to 3.46
3.475 rounds to 3.48
Using the function Round this way : "select Round(Nbr/1,2)*1"
gives me the following number
3.465 rounds to 3.47 (Not Ok)
3.455 rounds to 3.46 (Ok)
3.475 rounds to 3.48 (Ok)
Thinks to helping me
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|