[RESOLVED] Silly question (Rounding)

Have searched as always but it appears all the rounding done if for numbers like 10.34354 etc

I need to round off to the nearest 10 but not least, example


10 would stay as 10
11 would be 20
3 would be 10
22 would be 30

Thanks in advance :thumb:

try this

VB Code:

x = ((y \ 10) * 10) + IIf(y Mod 10, 10, 0)

Or:

y = -Int(-x/10)*10

Thanks!