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.
|