View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Sho

you might like to play with
=ROUND(62.675,0)
=ROUNDUP(62.675,0)

which will both (in this case) return 63
and for completion sake have a look at
=ROUNDDOWN(62.675,0)
which will return 62

Cheers
JulieD

"Sho" wrote in message
...
Is there a function that will round decimals to the nearest 10 e.g. if I
had
62.675 I would want it to round to 63.