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

Hi Barney,

Are you looking for the Ceiling() function?, Command Window example:

i = 89764
? i, CEILING(i / 10) * 10
n = 89.764
? n, CEILING(n * 100) / 100

hth

-Stefan