rounding to nearest 10 fig

[Ben Ball]

I can use a calc to round figures off to 1 whole number or to 2 decimal places

using Round(fig1);2) or Round(fig2);0)

But how can I round to the nearest 10?

i.e a number of 459 will find 460

likewise 454 will find 450?

Anyone with any ideas??

B

[Inky Phil]

I've got AN idea but I can't say it is the Best idea

Divide by 10

round the result

multiply by 10

HTH

Phil

[Lee Smith]

Hi Phil,

Nothing wrong with it, especially for v6.

BTW [color:orange]Ben, the calculation would look like:

Round(YourNumberFieldHere / 10, 0) * 10

HTH

Lee

[Ben Ball]

Excellent, Thanks Lee, that clears that one,...

Ben