Post reply

rounding

  • November 13, 2012 at 2:39 am

    #270149

    Im performing some calculations and I need to round up the 2 decimal places to the next highest place

    eg

    calculation result

    10.434 should become 10.44

    I cant seem to do this with the ROUND function, is the anything else that will do this ?

  • November 13, 2012 at 2:48 am

    #1558410

    Your rounding is not following correct rounding rules, typically anything between 0-4 is rounded down and 5-9 rounded up, so to round a value to 10.44 it would have to be between 10.435 and 10.444.

    Can you explain why your logic is not to follow standard rounding?

  • November 13, 2012 at 3:20 am

    #1558418

    SELECT CEILING(10.434 * 100)/100

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply