Round Function

• Melissa Castle

  SSC Journeyman

  Points: 79

  More actions

  August 12, 2005 at 8:43 am

  #89499

  Hi,

   

  I'm not getting the results I expect from the Round function.  I have:

  PRINT ROUND(478/15, 0) and it returns a result of 31, but I expect that it would return 32 because the actual value is 31.8666666666666666666666667 (I just held down the 6 till it looked right, I'm not sure if I have too many or too few, if it matters ).  BOL supports my claim - see ROUND functions, bottom of the page.

   

  It may be nit-picking, but my tester is nit-picky. 

   

  Thanks,

  Melissa

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  August 12, 2005 at 8:52 am

  #581786

  Try this:

  ROUND(478.0/15, 0)

  Your example is performing integer division, whereas you want to perform float division and then round.

  ---

• Melissa Castle

  SSC Journeyman

  Points: 79

  More actions

  August 12, 2005 at 9:35 am

  #581820

  Got it, makes sense.  Thank you!