>Hi guys
>
>Is there an easy way of using the native Rounding function(s) to round like
>
>i) To the Nearest 10 whereby 18571.47 becomes 18580.00 UP and 18570 Down ?
>ii) To the Nearest 5 Cent Where 18571.47 becomes 18571.50 Up and 18571.45 Down
>
>Currently I am using a complex String manipulation function to achieve this.
>
>
>Fred
? INT(18571.47/10)*10
? ROUND(18571.47/10,0)*10
? CEILING(18571.47/10)*10
? INT(18571.47/0.05)*0.05
? ROUND(18571.47/0.05,0)*0.05
? CEILING(18571.47/0.05)*0.05