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

hI sTEFAN...

Actually its like this....I am generating bills and it could end in a figure like $ 89,764

but I need to certify again in the bill that it is below the next highest figure...for eg. here it shoul be $ 89,770

Thanks for ur reply !!

Regs

Barney