Rounding a decimal number up to the nearest even tenth... 1

[alexjones]

Examples: 24.31 would round up to 24.4
24.48 would round up to 24.6.

Anybody got a slick way of doing this?

 

[gmmastros]

Multiply by 10. Use the ceiling function. Divide by 10.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[alexjones]

Thanks for the quick response. The kicker here is the requirement that the number be rounded up to the nearest EVEN tenth.

So 24.48 should round up to 24.6 and ceiling(24.48 * 10) / 10 yields 24.5.

alex

 

[gmmastros]

Sorry. I missed that part. Use 5 instead of 10.

Select ceiling(24.48 * ]!]5[/!]) / [!]5[/!]

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gmmastros]

Select ceiling(24.48 * [!]5[/!]) / [!]5 [/!]

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[alexjones]

That is very cool. Thank you!