>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
See the ceiling()
i: ?CEILING((18571.49-4.99)/10)*10
?CEILING((18570.0-4.99)/10)*10
ii:?CEILING((18571.45-0.04)/.05)*.05
?CEILING((18571.47-0.04)/.05)*.05