> Dear all,

>

> Please help me with this one !

>

> I need to convert a figure (numeric) to the nearest 10, using round I suppose,

>

> For eg., I get an answer/total of 89,764 it should be converted to 89,770

>

> I have tried round(ggg,10) but it does not work...

>

> Thank you!

>

> Barney

Hi Barney,

Aside from what Stefan has given you, you could also do like,

a = 89764
Edit: This fails if a = 89760, the answer becomes 89770 (as pointed out by Vilhelm in his post)
? a + (10-MOD(a,10))
or
Edit: These do not but I believe Stefan and Vilhem's solution are better.

:-)

? a + ABS(MOD(a,-10))
? a - MOD(a,-10)

My blog:

http://thereportersassistant.blogspot.com